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
Define joiner transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What do you understand by term role-playing dimension?
how to load rows into fact table in data warehouse
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What all join we can perform in LOOKUP transformation?
What is Cognos script editor?
What is the sql query overwrite in source qualifier in informatica
How can you validate all mappings in the repository simultaneously?
If informatica has its scheduler why using third party scheduler?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How can you generate reports in informatica?
Can we override a native sql query within informatica?
What is lookup change?
What is mapping debugger?