which one is better performance wise joiner or look up


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

What are the types of schemas we have in data warehouse.

0 Answers  


Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,


How will u find weather dimension table is big in size of a fact table?

1 Answers  


What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers  






What are the popular informatica products?

0 Answers  


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,


why we use source qualifier transformation?

16 Answers   Accenture,


What are the designer tools for creating transformations?

0 Answers   Informatica,


Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers  


what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,


Explain the different dimensions.

0 Answers  


Categories