Interested to Buy Any Domain ? << Click Here >> for more details...
on a day i load 10 rows in my target and on nextday i get
10 more rows add to my target but out of 5 are update row
how ican send them to target?how i can insert and update
the records
- 4 Answers
- 8617 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / arpit
For this a SCD type2 mapping has to be created which will handle both update and insert. This mapping will be having 2 target instances i.e. one instance for updating and other is for inserting records. Use router to divide the rows in two groups i.e. update and insert. In the pipeline for update target instance use the update strategy transformation for update.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to do unit testing in informatica?
difference between informatica 8.1.1 and 8.6
What is resilience time?
What is the function of union transformation?
How will the document be delivered to me?
Performance tuning in UNIX for informatica mappings?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
is it possible to index the data in cache of lkp transformation ?
What is union transformation?
can anyone suggest best free Talend data integration training online
How to partition the Session?
Does an informatica transformation support only aggregate expressions?
What is a passive transformation?
How can we store previous session logs?
Which transformation should we use to normalise the COBOL and relational sources?
