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
Differentiate between a database and data warehouse?
What is the use of transformation?
what is the hint? how to use it to reduce the query processing in program?
What are the differences between a connected lookup and unconnected lookup?
Differentiate between sessions and batches?
What is exclusive and normal mode for repository services?
explan ur project architecture?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Describe data concatenation?
How many ways a relational source definition can be updated and what are they?
What is the function of aggregator transformation?
What is powercenter on grid?
What is the use of target designer?
what is the complex transformation you used in informatica