Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

HOW DO YOU PARFORM INCREMENTAL LAOD ?

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


Please Help Members By Posting Answers For Below Questions

What is Data Caches size?

1127


What all join we can perform in LOOKUP transformation?

1019


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.

1340


What is the benefit of partitioning a session?

1235


Define joiner transformation?

1101


can anyone suggest best free Talend data integration training online

1742


can u any challenge your project?

2083


How to load the data from a flat file into the target where the source flat file name changes daily?

1097


How to update source definition?

1141


What is Session and Batches?

1148


how tokens will generate?

2248


What is meant by a domain?

1188


What is the function of union transformation?

1201


can you please explain me pre session and post session options?

7670


What is a dimensional model?

1033