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
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
where to store informatica rejected data? How to extract the informatica rejected data?
Can you use flat files in Mapplets.
What is the benefit of partitioning a session?
What are the components of Informatica? And what is the purpose of each?
Explain the difference between a data warehouse and a data mart?
What are the tasks that source qualifier perform?
how to load rows into fact table in data warehouse
draw informatica architecture 8.6 ?
What do you mean by filter transformation?
Implementation methodology
what is diff b/t sorter t/r and agg have the option sorter property...
What is source qualifier transformation in informatica?
list out all the transformations which use cache?
Briefly describe lookup transformation?