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?
Answer Posted / prasad
use scd3 concept or use scd2 concept
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How can repository reports be accessed without sql or other transformations?
What are pre and post-session shell commands?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the difference between stop and abort in informatica
What is a passive transformation?
explain about unit testing? in real time?
How to generate sequence numbers?
Explain the types of lookup transformation?
How do you change a non-reusable transformation to reusable transformation?
Whats there in global repository
Is it possible to revert a global repository to local one and why?
Write the prerequisite tasks to achieve the session partition?
What are the new features of Power Center 5.0?
what are the Methods For Creating Reusable Transformations?
Enlist the various types of transformations.