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 Data Caches size?
What all join we can perform in LOOKUP transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the benefit of partitioning a session?
Define joiner transformation?
can anyone suggest best free Talend data integration training online
can u any challenge your project?
How to load the data from a flat file into the target where the source flat file name changes daily?
How to update source definition?
What is Session and Batches?
how tokens will generate?
What is meant by a domain?
What is the function of union transformation?
can you please explain me pre session and post session options?
What is a dimensional model?