Interested to Buy Any Domain ? << Click Here >> for more details...
On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?
- 6 Answers
- 12995 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasad
use scd3 concept or use scd2 concept
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the differences between oltp and olap?
What are mapplets?
Enlist the tasks for which source qualifier transformation is used.
How to update or delete the rows in a target, which do not have key fields?
how tokens will generate?
What is the advantage of informatica?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the different ways to implement parallel processing in informatica?
Informatica Checkpoints
Differentiate between router and filter transformation?
Explain the difference between mapping parameter and mapping variable?
What are the modules in Power Center
What is the procedure for creating independent data marts from informatica 7.1?
Explain about cumulative Sum or moving sum?
