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


Please Help Members By Posting Answers For Below Questions

How can you define user defied event?

776


What is mapping debugger?

708


What is data caches/ index caches?

753


What is sorter transformation?

737


What is meant by incremental aggregation?

716






What are ETL Tools?

810


draw informatica architecture 8.6 ?

3602


Explain sessions?

730


Why update strategy and union transformations are active? Explain with examples.

894


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3693


Explain pmcmd command usage in informatica

856


How to use procedural logic inside infromatica?

799


What do you mean by blocking transformation?

734


What is the command used to run a batch?

719


Which transformation is needed while using the Cobol sources as source definitions?

879