when we use dynamic lookup,if condition matches what will be
the o/p?

Answers were Sorted based on User's Feedback



when we use dynamic lookup,if condition matches what will be the o/p?..

Answer / sujana

it updates the row in the cache r leaves it unchanged

Is This Answer Correct ?    12 Yes 0 No

when we use dynamic lookup,if condition matches what will be the o/p?..

Answer / chandra

This lookup property is recomended only for the mapping
where soures has duplicate records

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Informatica Interview Questions

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,


my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,


in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,


How to differentiate between the active and passive transformations?

0 Answers  


Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,






Where do you create/define mapping parameter and mapping variable?

1 Answers  


What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,


How to eliminate 1st and last rows from the source and load the inbetween rows.

5 Answers   Syntel,


Can you use one mapping to populate two tables in different schemas

2 Answers  


How do you remove duplicate records in informatica?

1 Answers  


How are indexes created after completing the load process?

0 Answers  


Can you access a repository created in previous version of Informatica?

1 Answers  


Categories