Tuesday, August 5, 2014

Informatica Scenario Based Questions And Answers - 1



1.       Q1. Design a mapping to load a target table with the following values from the above source?
department_no, employee_list
10, A
10, A,B
10, A,B,C
10, A,B,C,D
20, A,B,C,D,P
20, A,B,C,D,P,Q
20, A,B,C,D,P,Q,R
20, A,B,C,D,P,Q,R,S

Solution:
Step1: Use a sorter transformation and sort the data using the sort key as department_no and then pass the output to the expression transformation. In the expression transformation, the ports will be
department_no
employee_name
V_employee_list = IIF(ISNULL(V_employee_list),employee_name,V_employee_list||','||employee_name)
O_employee_list = V_employee_list

Step2: Now connect the expression transformation to a target table.

Q2. Design a mapping to load a target table with the following values from the above source?
department_no, employee_list
10, A
10, A,B
10, A,B,C
10, A,B,C,D
20, P
20, P,Q
20, P,Q,R
20, P,Q,R,S

Solution:
Step1: Use a sorter transformation and sort the data using the sort key as department_no and then pass the output to the expression transformation. In the expression transformation, the ports will be
department_no
employee_name
V_curr_deptno=department_no
V_employee_list = IIF(V_curr_deptno! = V_prev_deptno,employee_name,V_employee_list||','||employee_name)
V_prev_deptno=department_no
O_employee_list = V_employee_list

Step2: Now connect the expression transformation to a target table.

Q3. Design a mapping to load a target table with the following values from the above source?
department_no, employee_names
10, A,B,C,D
20, P,Q,R,S

Solution:
The first step is same as the above problem. Pass the output of expression to an aggregator transformation and specify the group by as department_no. Now connect the aggregator transformation to a target table.

How to generate sequence numbers using expression transformation?

Solution:
In the expression transformation, create a variable port and increment it by 1. Then assign the variable port to an output port. In the expression transformation, the ports are:
V_count=V_count+1
O_count=V_count

2. Design a mapping to load the first 3 rows from a flat file into a target?

Solution:
You have to assign row numbers to each record. Generate the row numbers either using the expression transformation as mentioned above or use sequence generator transformation.
Then pass the output to filter transformation and specify the filter condition as O_count <=3

3. Design a mapping to load the last 3 rows from a flat file into a target?

Solution:
Consider the source has the following data.
col
a
b
c
d
e

Step1: You have to assign row numbers to each record. Generate the row numbers using the expression transformation as mentioned above and call the row number generated port as O_count. Create a DUMMY output port in the same expression transformation and assign 1 to that port. So that, the DUMMY output port always return 1 for each row.

In the expression transformation, the ports are
V_count=V_count+1
O_count=V_count
O_dummy=1

The output of expression transformation will be
col, o_count, o_dummy
a, 1, 1
b, 2, 1
c, 3, 1
d, 4, 1
e, 5, 1

Step2: Pass the output of expression transformation to aggregator and do not specify any group by condition. Create an output port O_total_records in the aggregator and assign O_count port to it. The aggregator will return the last row by default. The output of aggregator contains the DUMMY port which has value 1 and O_total_records port which has the value of total number of records in the source.

In the aggregator transformation, the ports are
O_dummy
O_count
O_total_records=O_count

The output of aggregator transformation will be
O_total_records, O_dummy
5, 1

Step3: Pass the output of expression transformation, aggregator transformation to joiner transformation and join on the DUMMY port. In the joiner transformation check the property sorted input, then only you can connect both expression and aggregator to joiner transformation.

In the joiner transformation, the join condition will be
O_dummy (port from aggregator transformation) = O_dummy (port from expression transformation)

The output of joiner transformation will be
col, o_count, o_total_records
a, 1, 5
b, 2, 5
c, 3, 5
d, 4, 5
e, 5, 5

Step4: Now pass the ouput of joiner transformation to filter transformation and specify the filter condition as O_total_records (port from aggregator)-O_count(port from expression) <=2

In the filter transformation, the filter condition will be
O_total_records - O_count <=2

The output of filter transformation will be
col o_count, o_total_records
c, 3, 5
d, 4, 5
e, 5, 5

4. Design a mapping to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining records into table C?

Solution:
This is similar to the above problem; the first 3 steps are same. In the last step instead of using the filter transformation, you have to use router transformation. In the router transformation create two output groups.

In the first group, the condition should be O_count=1 and connect the corresponding output group to table A. In the second group, the condition should be O_count=O_total_records and connect the corresponding output group to table B. The output of default group should be connected to table C.

Friday, July 25, 2014

Android Interview Questions and Answers


 1. What is android?
A.Android is a stack of software for mobile devices which has Operating System, middleware and some key applications. The application executes within its own process and its own instance of Dalvik Virtual Machine. Many Virtual Machines run efficiently by a DVM device. DVM executes Java language byte code which later transforms into .dex format files.
2. What are the advantages of Android?
A. The following are the advantages of Android:
* The customer will be benefited from wide range of mobile applications to choose, since the monopoly of wireless carriers like AT&T and Orange will be broken by Google Android. * Features like weather details, live RSS feeds, opening screen, icon on the opening screen can be customized * Innovative products like the location-aware services, location of a nearby convenience store etc., are some of the additive facilities in Android. Components can be reused and replaced by the application framework. * Optimized DVM for mobile devices * SQLite enables to store the data in a structured manner. * Supports GSM telephone and Bluetooth, WiFi, 3G and EDGE technologies * The development is a combination of a device emulator, debugging tools, memory profiling and plug-in for Eclipse IDE.
3. Explain about the exceptions of Android?
A.The following are the exceptions that are supported by Android * InflateException : When an error conditions are occurred, this exception is thrown * Surface.OutOfResourceException: When a surface is not created or resized, this exception is thrown * SurfaceHolder.BadSurfaceTypeException: This exception is thrown from the lockCanvas() method, when invoked on a Surface whose is SURFACE_TYPE_PUSH_BUFFERS * WindowManager.BadTokenException: This exception is thrown at the time of trying to add view an invalid WindowManager.LayoutParamstoken.
4. Describe the APK format.
A.The APK file is compressed the AndroidManifest.xml file, application code (.dex files), resource files, and other files. A project is compiled into a single .apk file.
5. What is .apk extension?
A.The extension for an Android package file, which typically contains all of the files related to a single Android application. The file itself is a compressed collection of an AndroidManifest.xml file, application code (.dex files), resource files, and other files. A project is compiled into a single .apk file.
6. What is .dex extension?
A.Android programs are compiled into .dex (Dalvik Executable) files, which are in turn zipped into a single .apk file on the device. .dex files can be created by automatically translating compiled applications written in the Java programming language.
7. Explain the Architecture of Android ?
A. Top -> Applications (Contacts, Browser, Phone, etc)
Below Applications -> Application Framework(Activity Manager, Window Manager, Content Providers, View System, Package manager,
Telephony manager, Resource, Notification, Location managers)
Below Application Framework -> System Libraries(Like Sqlite, webkit, SSL, OpenGL, Media Framework etc) & Android Runtime( Core Libraries and DVM).
Atlast Last -> Linux Kernel (which composed of drivers like display, camera etc.)
10. What is an activity?
A. A single screen in an application, with supporting Java code.
An activity presents a visual user interface for one focused endeavor the user can undertake.
For example, an activity might present a list of menu items users can choose from or it might display photographs along with their captions.
11. What is a service?
A.A service doesn’t have a visual user interface, but rather runs in the background for an indefinite period of time.
For example, a service might play background music as the user attends to other matters, or it might fetch data over the network or calculate something and provide the result to activities that need it.Each service extends the Service base class.

ASP.net Interview Questions and Answers



What is ASP?
ASP stands for Active Server Pages. It is a server side technology which is used to display dynamic content on web pages. For example you could write code that would give your visitors different information, different images or even a totally different page depending on what browser version they are using.
How can you disable the browser to view the code?
Writing codes within the Tag
What is a "Virtual Directory"?
Virtual directories are aliases for directory paths on the server. It allows moving files on the disk between different folders, drives or even servers without changing the structure of web pages. It avoids typing an extremely long URL each time to access an ASP page.
Give the comment Tags for the following?
VBScript : REM & ‘(apostrophe)
JavaScript : // (single line comment)
/* */ (Multi-line comments)
Which is the default Scripting Language of ASP (server-side)?
VBScript
Which is the default Data types in VBScript?
Variant is the default data type in VBScript, which can store a value of any type.
What is a variable?
Variable is a memory location through which the actual values are stored/retrieved. Its value can be changed.
What is the maximum size of an array?
Up to 60 dimensions.
What is Query string collection?
This collection stores any values that are provided in the URL. This can be generated by three methods:
By clicking on an anchor tag
By sending a form to the server by the GET method
Through user-typed HTTP address

It allows you to extract data sent to the server using a GET request.
What are the attributes of the tags? What are their functions?
The two attributes are ACTION and METHOD
The ACTION gives the name of the ASP file that should be opened next by which this file can access the information given in the form The METHOD determines which of the two ways (POST or GET) the browser can send the information to the server
What are the methods in Session Object?
The Session Object has only one method, which is Abandon. It destroys all the objects stored in a Session Object and releases the server resources they occupied.
What is ServerVariables collection?
The ServerVariables collection holds the entire HTTP headers and also additional items of information about the server.
What is the difference between Querystring collection and Form collection?
The main difference is that the Querystring collection gets appended to a URL.
What is a Form collection?
The Form collection holds the values of the form elements submitted with the POST method. This is the only way to generate a Form collection.
What are the ASP Scripting Objects?
The Dictionary object, the FileSystemObject object, TextStream object.
What happens to a HTML page?
The browser makes a HTTP request; the server gives a HTTP response to the browser and the browser converts into a HTML page.
What happens to ASP pages?
The browser makes a HTTP request; the server does the processing and gives a HTML response to the browser.
How can you change the primary scripting language for a page?
Specify
What is application Object?
Shares information among users of an application. Gives a notification when an application starts or ends.
What is the difference between client-side script and server-side script?
Scripts executed only by the browser without contacting the server is called client-side script. It is browser dependent. The scripting code is visible to the user and hence not secure. Scripts executed by the web server and processed by the server is called server-side script.
What is the command to display characters to the HTML page?
Response.Write

Monday, July 21, 2014

Wipro Campus Walkin for Freshers on 26th July and 2nd and 3rd August

Job Description:
We are hiring Science graduates ready to take up challenging roles within our Global Infrastructure Services (GIS) Division in a 24X7 Operation Setup. This would involve interaction with clients (internal and external) and providing technological support.
Roles and Responsibilities:
ƒnƒn
„h First-level incident / problem determination and resolution on a 24x7 basis.
„h Service incidents and queries within the agreed service levels.
„h Customer interaction with excellent communication skills
„h Perform daily, weekly and monthly proactive maintenance and monitoring activities.
„h Follow quality / security & disciplinary compliances expected to manage global customers & as defined for the workplace.
„h Support & Monitoring of availability, capacity usage, errors and failures on Compute, storage and network platforms.
„h Support & Monitoring of applications, processes, OS, job scheduling, etc.
„h Teaming & Timely escalation of incidents to higher level when required.
Eligibility for the recruitment drive :
¡E BCA / B.Sc (All branches except Nursing/Agriculture/Hotel management) / M.Sc (All branches). Only FULL TIME programs. ¡E Year of Passing : 2014 only. ¡E 40% and above in 10th and 12th std. 50% and above in graduation and post-graduation.
Job Title
Project Engineer
Location
Across all Wipro locations in India
¡E No standing arrears.
¡E M.Sc. 5 years Integrated course is not considered for this requirement.
Candidates who have appeared in last 3 months for the Wipro recruitment process are also eligible to participate in this Walk-in drive.
Selection Process:
Online Aptitude Test followed by Interviews.
Other instructions :
„» All the candidates must carry the following documents for participating in the recruitment drive.
1. 2 passport size photographs
2. College ID Card/A valid photo id proof
3. 1 Copy of Resume
4. Photocopies of all the mark sheets 10th std , 12th std, UG and PG (If applicable)
„» All the candidates appearing for the online test must have a valid and active email-id compulsorily



For applying and details check below link.

Wipro Campus Walkin for Freshers on 26th July and 2nd and 3rd August

Friday, July 18, 2014

Walk-in Drive - 19th July-14 - SAP Basis @ Ciber

Hi This is regarding SAP Basis opportunity with Ciber Bangalore location.on  19th July,2014.
 
Venue
 
Work Location Bangalore
Date 19-July-14 (Saturday)
Time 9:30 AM to 03:00 PM
 

CIBERsites India Private Limited
6th floor, Block B, WTC -3,
Bagmane World Technology Centre,
Bagmane constructions Pvt ltd SEZ
KR Puram Marathahalli Ring Raod,
Mahadevapura and Doddanekundi,
Krishnarajapuram, Hobli,
Bangalore East Taluk 560037

Contact person: Madan

JD

"At least 5 years of experience in SAP Basis/Netweaver administration
Experience on administration of SAP ABAP and JAVA stacks.
Experience troubleshooting issues with BI, EP and PI systems.
Experience in performance tuning of SAP systems.
Experience in performing support pack and Kernel upgrades.
Experience in configruration of central monitoring.
Experience in Configuration of EWA reports and analysis.
Experience working on MS SQL and ASE databases
Experience in working in a fast paced environment
Experience in interacting with customers
Experience with SAP systems in a Development, QAS and Production environments

Responsibilities:
Incident management for a pool of projects.
Problem analysis and resolutions along with preparation of RCA documents.
Change analysis and execution.
Configuring EWA reports. Analyze and prepare recommendations based on EWA.
Monitor the production systems using tools like Xandria/Solution manager.
Monitor and secure the Prod Environment for Security violations" 


For details check the below link

Walk-in Drive - 19th July-14 - SAP Basis @ Ciber 

 

Thursday, July 17, 2014

Walk-in for Java/J2EE @ Persistent on 20th July!!

 Walk-in for Java/J2EE @ Persistent on 20th July!!

Job Description
Expertise in:
- Experience in Core Java, J2EE framework
- Strong knowledge of JSP/Servlets/Struts/Hibernate/Spring
- Experience in SQL, OOPS, Design Patterns & Multi-Threading
Think you have it in you? Walk in with your CV, latest salary revision letter & a passport-size photo
On: Sunday, 20th July 2014
Time: 10:00 AM - 3:00 PM
Venue:
Persistent Systems, Aryabhata-Pingala, Opp. Sharda Centre,
Off Karve Road, Erandawana, Pune 411 004


For details Check below link

Wednesday, July 16, 2014

Walkin Interviews for SAP FICO Consultant @ TCS

Walkin Interviews for SAP FICO Consultant @ TCS Bangalore

Job Summary:
 
Experience:  3 - 7 years.
 
Job Location: Kochi
 

Must Have:
  1. Min. 1 E2E Implementation as FI Consultant
  2. At Least 1 Support project Experience as FI Consultant
  3. Good SAP FI Configuration Skills,
  4. Must know writing Functional Specs for Complex WRICEF developments,
  5. SAP CO working knowledge

Eligibility:
  1. BE/ B Tech/ ME/ M Tech/ M. Sc / MCA / MCM/ MS/ MBA (with IT/ Systems/Finance)/ CA / ICWA.
  2. Only B. Sc, BCA & Technical Diploma (3 Yrs) with min 4 yrs relevant IT experience.
  3. Consistent academic record is a must i.e. 50% and above
  4. A candidate should not have more than 2 years of break in Career / Academics or Non - IT Experience
  5. Correspondence or Part time courses will not be considered.
  6. Candidates interviewed by TCS in the last 6 months are not eligible.

Documents Required:
  1. Create profile on tcscareers.com and bring dully filled in TCS Online Application Form copy *
  2. Resume
  3. Passport size photo
  4. Last 3 months pay-slip copies
  5. Original & Xerox Copy of PAN Card / Passport
  6. Previous Experience Certificates for all the Previous Employment
  7. Copy of Relieving Letters of all previous companies (Current Company if applicable)


Interview Date: Sunday, 22 July 2014.
 
Interview time: 09:30 AM to 01:00 PM.
 

Venue:
TATA Consultancy Services
Abhilash Building, Plot No. 96
EP-IP Industrial Area, Whitefield Road,
Bangalore 560 066


 
Contact person: Narendran R.

For more details check below link

Walkin Interviews for SAP FICO Consultant @ TCS