How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
Answer Posted / suresh
scd type 2
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
write a query to retrieve the latest records from the table sorted by version(scd)
What is event and what are the tasks related to it?
Define the various join types of joiner transformation?
Differentiate between sessions and batches?
What is informatica metadata and where is it stored?
Enlist few areas or real-time situations where informatica is required.
How we can create indexes after completing the load process?
When do you use sql override in a lookup transformation?
What are the different transaction levels available in transaction control transformation?
Can we create two repositories on same database instance in oracle?
What is sq transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is lookup transformation?
How to call shell scripts from informatica?
During the running session, output files are created by informatica server. Enlist few of them.