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 complex mapping?

1119


Explain lookup transformation in informatica

1070


What is difference between a gateway node and worker node?

1135


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

7562


How to generate sequence numbers?

1082


if we have a delimiters at unwanted places in a flat file how can we over come those.

2045


What is primary and backup node?

1125


What is data caches/ index caches?

1098


What is the format of informatica objects in a repository?

1019


What are different types of transformations available in informatica?

987


Which transformation is needed while using the Cobol sources as source definitions?

1168


What is a filter transformation and why it is an active one?

968


What is sq transformation?

1160


What is union transformation?

963


How many number of sessions can one group in batches?

1157