If session fails after loading 10000 records in the
target,how can we load 10001 th record when we run the
session in the nexttime?
Answer Posted / basu
I think his question is, he wants to loads incremental. so you can go for Change data capture by using mapping variable/parameters in the SQ query overid
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is intricate mapping?
Is there any way to read the ms excel datas directly into informatica?
Enlist few areas or real-time situations where informatica is required.
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?
How you know when to use a static cache and dynamic cache in lookup transformation?
Under which circumstances, informatica server creates reject files?
What is the session task and command task?
Scheduling properties,whats the default (sequential)
What are the restrictions of union transformation?
Differentiate between router and filter transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is the difference between Active and Passive transformation?
What is meant by active and passive transformation?
What is a filter transformation?
Can we create two repositories on same database instance in oracle?