Informatica interview questions

I have a situation here to load the Table into informatica.I have 5 temporary tables as sources. They look like:Table1: (K - Key, N-Null, X,Y,Z - values)K1 X N N N NK2 X N N N N--------------------------Table2: K1 N X N N NK2 N X N N N--------------------

What will happen if you are using Update Strategy Transformation and your session is configured for "insert"? What are the types of External Loader available with Informatica? If you have rank index for top 10. However if you pass only 5 records, what will

How can we join the tables if the tables have no primary and forien key relation and no matchig port to join?

This is a scenario in which the source has 2 cols10 A 10 A20 C30 D40 E20 CAnd there should be 2 targets one to show the duplicate values and another target for distinct rows.T1 T210 A 10 A20 C 20 C30 DWhich transformation can be used to

In certain mapping there are four targets tg1,tg2,tg3 and tg4.tg1 has a primary key,tg2 foreign key referencing the tg1's primary key,tg3 has primary key that tg2 and tg4 refers as foreign key,tg2 has foreign key referencing primary key of tg4 ,the or

In a filter expression we want to compare one date field with a db2 system field CURRENT DATE.Our Syntax: datefield = CURRENT DATE (we didn't define it by ports, its a system field ), but this is not valid (PMParser: Missing Operator)..Can someone hel

My source is having 1000 rows. i have brought 300 records into my ODS. so next time i want to load the remaining records. so i need to load from 301 th record. when ever i start the work flow again it will load from the begining. how do we solve this prob

If u had to split the source level key going into two seperate tables. One as surrogate and other as primary. Since informatica does not gurantee keys are loaded properly(order!) into those tables. What are the different ways you could handle this type of

What are the types of maping wizards that r to be provided in Informatica?

In the concept of mapping parameters and variables, the variable value will be saved to the repository after the completion of the session and the next time when u run the session, the server takes the saved variable value in the repository and starts ass

Can u explain one critical mapping?performance issue which one is better? whether connected lookup tranformation or unconnected one?

In the source, if we also have duplicate records and we have 2 targets, T1- for unique values and T2- only for duplicate values. How do we pass the unique values to T1 and duplicate values to T2 from the source to these 2 different targets in a single map

What is difference between lookup cashe and unchashed lookup? Can i run the mapping with out starting the informatica server?

What is meant by lookup caches?

What are the settiings that u use to cofigure the joiner transformation?

What are the types of lookup caches?

How do you create single lookup transformation using multiple tables?

What are the active and passive transformations?

Somebody ca explain me the 3 points:I want to Know :1) the differences between using native and ODBC server-side databaseConnections2)Know the reason why to register a server to the repository is necessary3)Know the rules associated with transferring and

What are the reusable transformations?

What is difference between dimention table and fact table and what are different dimention tables and fact tables

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

My source table look likeID Name Location Salary1 ran NULL NULL1 NULL DELHI NULL1 NULL NULL 1000I want my output to look likeID Name Location Salary1 ran Delhi 1000What should be my approach to design a informatica mapping.Assuming my source is flat file not a Relation table so i cant use SQL.

If I have set the property Treat Source Rows as Insert andfor the target properties I have checked the boxes Update asUpdate, what will happen to incoming rows? What exactly is the use of these check boxes and in whichscenarios we use them. Also what is the sequence in whichinformatica understands these properties.Does it takeswhatever is defined in treat source rows as property or itis in any other way. Please explain.

If we use sorted ports in aggregator transformationand somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

Where we use dynamic lookup and where we use it?do wegenerate surrogate keys using dynamic lookup?can we use itfor scd type 2 mapping and why?

Can we delete the Billing transaction?

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

What are the limitations of pushdown optimization technique ? Advance thanks

Is LOAD MANAGER AND LOAD BALANCER same in informatica?