How you know when to use a static cache and dynamic cache in lookup transformation?


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

Post New Answer

More Informatica Interview Questions

can u any challenge your project?

0 Answers   HP,


Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,


How do you update the records with or without using update strategy?

0 Answers  


How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  


What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,






Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  


How would you join a node to the already existing domain?

0 Answers  


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,


How can we update a record in the target table without using update strategy?

0 Answers  


What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,


Which version configuration tool used in ur project?

0 Answers   CTS, TCS,


How many number of sessions can one group in batches?

0 Answers  


Categories