Interested to Buy Any Domain ? << Click Here >> for more details...
one source to target loading insert new rows and update
existing rows?
- 3 Answers
- 7344 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / s
We can achieve this
SRC->EXP->UPD->TGT.
In Update Transformation put DD_UPDATE. And in target add
update_override to update the required columns based on the
condition. At session level set the target load attribute
as INSERT, UPDATE ELSE INSERT.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is informatica powercenter repository?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Where do we use mapping variables in informatica?
How to extract sap data using informatica?
Explain how to import oracle sequence into informatica?
Write the advantages of partitioning a session?
What is lookup change?
Define sessions in informatica etl?
What is the difference between informatica 7.0 and 8.0?
What is the sql query overwrite in source qualifier in informatica
How can repository reports be accessed without sql or other transformations?
Mention few advantages of router transformation over filter transformation.
What do you understand by a term domain?
How many input parameters can exist in an unconnected lookup?
What is Session and Batches?
