Answer Posted / sagar chowdary
By using the date column in the source we do incremental load,
specifying the start date in source qualifier,changing the
start date in parameter file in future.
With this in mind, I will expect a load pattern like this
Every extract from the source will be a full load
Every load in terms of records, will be equal to last load + new records – deleted records
80-90 % of the extracted records will already exist in the valid table instance
Every load will be incrementally larger than the previous load, as more records are added to the sourceThinking
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is complex mapping?
Explain lookup transformation in informatica
What is difference between a gateway node and worker node?
can you please explain me pre session and post session options?
How to generate sequence numbers?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is primary and backup node?
What is data caches/ index caches?
What is the format of informatica objects in a repository?
What are different types of transformations available in informatica?
Which transformation is needed while using the Cobol sources as source definitions?
What is a filter transformation and why it is an active one?
What is sq transformation?
What is union transformation?
How many number of sessions can one group in batches?