which one is better performance wise joiner or look up
No Answer is Posted For this Question
Be the First to Post Answer
What are the types of schemas we have in data warehouse.
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
How will u find weather dimension table is big in size of a fact table?
What are the unsupported repository objects for a mapplet?
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?
What are the popular informatica products?
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?
why we use source qualifier transformation?
What are the designer tools for creating transformations?
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.
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
Explain the different dimensions.