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 / sid

take a look t/f and a update strategy t/f. basing on look
up , if the record exits in target then reject it ,if not
exit insert it,and if the record exist but it is changed
then update it

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the size of your data warehousing?

1858


How many ways are there to do 'remove duplicate records in informatica'?

777


Define mapplet?

803


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1709


What you know about transaction control transformation?

759


What is powercenter on grid?

935


Explain lookup transformation is active in informatica

857


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1862


Explain pushdown optimization $pushdownconfig parameter - informatica

911


State the limitations where we cannot use joiner in the mapping pipeline?

767


What are the new features of informatica 9.x developer?

742


How can we handle two sessions in informatica?

795


What is domain in terms of informatica?

772


Under what condition selecting sorted input in aggregator may fail the session?

873


Target increases every day even though no new record was inserted

1338