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 the difference between informatica 7.0 and 8.0?
Can we create two repositories on same database instance in oracle?
How to load a Dimension ? and how to load a fact table?
What are the databases that informatica can connect to windows?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is the use of code page?
whats the logic to load the lower level of granularity of data to fact table.
Mention some types of transformation?
What is Cognos script editor?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is a mapplet/worklet in informatica?
What is incremental aggregation?
What is the difference between router and filter?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
hi real timers . iam waiting for ur reply regarding ETL TESTING
