Informatica Interview Questions with Answers

3/03/2010 No Comment

Informatica Interview Questions, Data Warehouse Questions and Answers on Informatica.

Flat file is having 10 records as input and I want to push 5 records to the target?
Ans :
 one variable with the name $$count at mapping variable with a Count aggregation type and initial value for that $$count=0. Create one expression and use SETCOUNTVARIABLEv_count=SetCountVariable ($$Count) Create one filter after expression and put condition v_count <=5 

Explain what is the difference between source qualifier transformation and application source qualifier transformation?
 The Source qualifier transformation extracts data from RDBMS or from a single flat file system. Application source qualifier transformation extracts data from application sources like ERP.

Explain what is a mapplet in Informatica?
A mapplet is nothing but a reusable object that is created by using mapplet designer. The mapplet contains set of transformations which allows us to reuse that transformation logic in multiple mappings.

Explain what does reusable transformation mean 
in Informatica?
Ans: Reusable transformations can be used multiple times in a mapping. The reusable transformation is stored as a metadata separate from any other mapping that uses the transformation. Whenever any changes to a reusable transformation are made, all the mappings where the transformation is used will be invalidated.

Explain how can we create primary key only on odd numbers?
To create primary key, we use sequence generator and set the 'Increment by' property of sequence generator to 2.

What do you mean by a authenticator?
It validates user name and password to access the PowerCenter repository.

What is the use of auxiliary mapping?
Auxiliary mapping reflects change in one table whenever there is a change in the other table.

How the Informatica server sorts the string values in Rank transformation?
When the Informatica server runs in the ASCII data movement mode it sorts session data using Binary sort order. If you configure the session to use a binary sort order, the informatica server calculates the binary value of each string and returns the specified number of rows with the highest binary values for the string.

Why we use stored procedure transformation?
For populating and maintaining data bases.

What are the rank caches?
During the session, the Informatica server compares an input row with rows in the data cache. If the input row out-ranks a stored row, the Informatica server replaces the stored row with the input row. The informatica server stores group information in an index cache and row data in a data cache.

What is the Rank index in Rank transformation?
The Designer automatically creates a RANKINDEX port for each Rank transformation. The Informatica Server uses the Rank Index port to store the ranking position for each record in a group. For example, if you create a Rank transformation that ranks the top 5 salespersons for each quarter, the rank index numbers the salespeople from 1 to 5.
Explain what is the difference between Normal load and Bulk load?
Ans: The difference between Normal Load and Bulk Load is cited below.

Normal Load: Normal load will write information to the database log file so that if any recovery is needed it is will be helpful. when the source file is a text file and loading data to a table, in such cases we should you normal load only, else the session will be failed.

Bulk Mode: Bulk load will not write information to the database log file so that if any recovery is needed we can't do any thing in such cases.
comparatively Bulk load is pretty faster than normal load.
Related Posts

No comments :


Aired | The content is copyrighted and may not be reproduced on other websites. | Copyright © 2009-2016 | All Rights Reserved 2016

Contact Us | About Us | Privacy Policy and Disclaimer