how to create a sample mapping for dynamic lookup
transformation
Answer Posted / abhinaw prakash
when you use dynamic lookup t/r a new row will be added to the lookup(lookup row port).
Use a router for insert and update.
have 2 update strategy t/r and give the xpression lookuprow port as 1(insert) and 2(update).
connect it to the target.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we store previous session logs?
What are the types of schemas we have in data warehouse.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the sql query overwrite in source qualifier in informatica
How can we improve session performance in aggregator transformation?
what is index?how it can work in informatica
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is the procedure for creating independent data marts from informatica 7.1?
What are the types of caches in lookup? Explain them.
Slowly changing dimensions, types and where will you use them
tell me about your project functionality
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Explain your project of banking domian.
How we can create indexes after completing the load process?