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
- 7285 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
Explain the pipeline partition with real time example?
What are active transformations.
What is data movement mode in Informatica and difference between them?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain sessions and how many types of sessions are there?
How identifying bottlenecks in various components of informatica and resolving them?
can anyone explain me about retail domain project in informatica?
list out all the transformations which use cache?
What is meant by lookup transformation? Explain the types of lookup transformation?
How does a sorter cache works?
How can we remove the duplicates from flat file source?
What is the command used to run a batch?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Define mapping and session?
Can u generate reports in Informatica?
