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
Answer Posted / rajendra kommineni
WE CAN USE SCD TYPE1
i.e BY USING UPDATE STATERGY
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What is the difference between informatics 7x and 8x and what is latest version?
Do you find any difficulty while working with flat files as source and target?
Describe the impact of several join conditions and join order in a joiner transformation?
What is powercenter on grid?
Differentiate between reusable transformation and mapplet.
Name the different lookup cache(s)?
What is target load order?
Quickly characterize reusable change?
According to his methodology what all you need before you build a datawarehouse
What are active and passive transformations?
How to handle decimal places while importing a flatfile into informatica?
How to do unit testing in informatica? How to load data in informatica ?
I have a flat file, want to reverse the contents of the flat file
What is option by which we can run all the sessions in a batch simultaneously?
How we can create indexes after completing the loan process?