Prepare for your Next Interview
This is a discussion on Incremental Loading with flat file within the Data Warehousing forums, part of the Databases category; Is there any way that we can do incremental loading if both source and target are flat files? Can any one respond to this please?...
|
|||
|
Yes you can always do incremental load no matter your target and source are flat files are not. But make sure to check the Append if Exists in session properties in mappings tab for target. And one more thing, if you are appending header to output target table it gets appended for first load, for next load only data gets appended.
|
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Flat File Optimization | amarsbahrani | Oracle | 3 | 06-19-2008 04:34 AM |
| Load 3 flat file in single shot | rameshpossible | Data Warehousing | 1 | 09-24-2007 11:52 PM |
| Selected row from mid of flat file | mathavadoss | Data Warehousing | 1 | 09-20-2007 12:33 AM |
| Constraint based loading and incremental aggretation | Geek_Guest | Data Warehousing | 0 | 04-06-2007 03:46 AM |
| Loading Library at Run time (.vbs file) | psuresh1982 | VB.NET | 2 | 02-01-2007 07:18 AM |