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
in reporting we add some new objects,how we get the count of the newly added objects to the report
Differences between version 7.x and 8.x.
Describe the impact of several join conditions and join order in a joiner transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to extract sap data using informatica?
Explain what are the different versions of informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
what is $$$$?
Quickly characterize reusable change?
Briefly define reusable transformation?
Explain lookup transformation source types in informatica
which one is better performance wise joiner or look up
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain the use of aggregator cache file?
What is the surrogate key?