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 / chandrasekar
Hi Sudhar,
Please check your answer it is not working....
We can use the SCD type 1 only get the new row as insert
into target and updated record as update into target.
If it wrong means please mail me.. chandranmca2007@gmail.co
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the transformations that are not supported in mapplet?
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
What is primary and backup node?
Explain the tuning lookup transformation - informatica
What is enterprise data warehousing?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Where can we find the throughput option in informatica?
Does an informatica transformation support only aggregate expressions?
What is meant by lookup transformation?
What is DR strategy for Informatica project?
What are the informatica performance improvement tips
What are the types of lookup transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is lookup change?
What are pre and post-session shell commands?