Interested to Buy Any Domain ? << Click Here >> for more details...
HOW DO YOU PARFORM INCREMENTAL LAOD ?
- 7 Answers
- 16731 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 is an MDDB? What is the difference between MDDBs and RDBMSs?
hi all, Can anyone please tell me the relationship between informatica and business objects
What is a passive transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
What are Dimensional table?
What is update override?
What are the types of maping wizards that r to be provided in Informatica?
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
How to get EVEN & ODD numbers separately?
What is the exact difference b/w IN and EXIST in Oracle..?
How do we call shell scripts from informatica?
Explain the features of connected and unconnected lookup.
Teradata 
