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
- 8603 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
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?
What is the need of an ETL tool?
What is xml source qualifier transformation in informatica?
How do you set a varible in incremental aggregation
What is the sql query overwrite in source qualifier in informatica
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Why filter transformation is an active one?
What is informatica etl tool?
What are batches?
Explain the tuning lookup transformation - informatica
What is informatica? Why do we need it?
can we override a native sql query within informatica? How do we do it?
Mention few advantages of router transformation over filter transformation.
If informatica has its scheduler why using third party scheduler?
What are roles and groups and benefits of using them?
