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
pmscmd startworkflow -sv
What is workflow manager?
difference between informatica 8.1.1 and 8.6
What do think which one is the better joiner or look up?
Which transformation is needed while using the Cobol sources as source definitions?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain joiner transformation in informatica
Can we create two repositories on same database instance in oracle?
What is lookup change?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How you can differentiate between connected lookup and unconnected lookup?
Does an informatica transformation support only aggregate expressions?
Define enterprise data warehousing?
How do you load only null records into target? Explain through mapping flow.
Explain sessions. Explain how batches are used to combine executions?