Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to load the data from a flat file into the target where the source flat file name changes daily?
How can you generate reports in informatica?
What are the different transaction levels available in transaction control transformation?
How you can differentiate between connected lookup and unconnected lookup?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
lookup transformation with screenshots
What is main use of mapplet?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is mapping debugger?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is meant by active and passive transformation?
How to Create a folder using pmrep command?
Describe an informatica powercenter?
what is Active lock explain
waht type of interface is used for testing the data in informatica
