Interested to Buy Any Domain ? << Click Here >> for more details...
HOW DO YOU PARFORM INCREMENTAL LAOD ?
- 7 Answers
- 16750 Views
- SAIC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subbu
by using the date coll in the source we do incremental load,
specifying the start date in source qualifier,changing the
start date in parameter file in future.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / praveen
Taking the Target defination as source and using the joiner
and update we can do the incremental loading
2.By using lookup transformation, keeping lookup on target
and companring.
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / tshiwela
you can perform increamental load by using auxiliary
parameters.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / sudhakar
BY USING MAPPINING VARIABLES,FIRST DEFINE THE VARIABLE
E.DATE AND NEXT COMPARE E.DATE,IF IT MATCHES THEN DATA
AUTOMATICALLY LOADED.
| Is This Answer Correct ? | 0 Yes | 0 No |
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 |
Answer / vaschiky
Disable truncate target table option from session target
table properties.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the reusable transforamtions?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
scenario
what are the limitations of pushdown optimization technique ? Advance thanks
How many numbers of sessions can one group in batches?
What do you mean by blocking transformation?
Under which circumstances, informatica server creates reject files?
How to go to the older version for a mapping?
Performance tuning in UNIX for informatica mappings?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
What is meant by active and passive transformation?
Teradata 
