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 / abhinaw prakash

We can use Update strateGY TO execute the following scenario

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain pushdown optimization and types in informatica

661


What are some examples of informatica etl programs?

528


What is the need for an etl tool?

628


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

651


What is decode in informatica?

648






Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

594


Explain what transformation and how many are there in informatica?

479


What are the different clients of powercenter?

592


What are the main features of Oracle 8i with context to datawarehouse?

1673


Define pmcmd command?

616


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2269


Plz can any one say me how to get the informatica certification materials and dumps

1591


what is the Default Source Option For Update Strategy Transformation?

751


How does a rank transform differ from aggregator transform functions max and min?

665


What is intricate mapping?

586