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 you define user defied event?
What is mapping debugger?
What is data caches/ index caches?
What is sorter transformation?
What is meant by incremental aggregation?
What are ETL Tools?
draw informatica architecture 8.6 ?
Explain sessions?
Why update strategy and union transformations are active? Explain with examples.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain pmcmd command usage in informatica
How to use procedural logic inside infromatica?
What do you mean by blocking transformation?
What is the command used to run a batch?
Which transformation is needed while using the Cobol sources as source definitions?