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
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Why update strategy and union transformations are active?
How can informatica be used for an organization?
explan ur project architecture?
What is deployment group?
Define mapplet?
Which version configuration tool used in ur project?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What are the advantages of using informatica as an etl tool over teradata?
Mention some types of transformation?
Explain informatica architecture - version 8 / 9
What is event and what are the tasks related to it?
What are the data movement modes in informatica?
What are the types of schemas we have in data warehouse.
What is the difference between informatica 7.0 and 8.0?