Answer Posted / praveen
Taking the Target defination as source and using the joiner
and update we can do the incremental loading
2.By using lookup transformation, keeping lookup on target
and companring.
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
Informatica settings are available in which file?
What is a router transformation?
What are the popular informatica products?
How can repository reports be accessed without sql or other transformations?
what is song in infrmatica...?
What is a dimensional model?
Performance tuning( what you did in performance tuning)
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
draw informatica architecture 8.6 ?
How to configure mapping in informatica?
How to create the source and target database connections in server manager?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the difference between Active and Passive transformation?
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?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?