can v update d records in target using update stargey
without generationg primary key ? explain
Answer Posted / leo gilbert
By using "Update override" option in the target. Say the
key of your table is ID,NAME. But your mapping is passing
only ID to the target then you can have an update override
query in the target to update the target only based on
ID.
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Differentiate between a database and data warehouse?
Have you worked with/created Parameter file
Target increases every day even though no new record was inserted
Can anyone tell me the new features in Informatica 9 Version?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How an expression transformation differs from aggregator transformation?
What is rank transformation in informatica
What is Index Caches size?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is blocking transformation?
What are mapplets?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the function of aggregator transformation?