Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
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 | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Flat File Optimization | amarsbahrani | Oracle | 3 | 06-19-2008 05:34 AM |
| Load 3 flat file in single shot | rameshpossible | Data Warehousing | 1 | 09-25-2007 12:52 AM |
| Selected row from mid of flat file | mathavadoss | Data Warehousing | 1 | 09-20-2007 01:33 AM |
| Constraint based loading and incremental aggretation | Geek_Guest | Data Warehousing | 0 | 04-06-2007 04:46 AM |
| Loading Library at Run time (.vbs file) | psuresh1982 | VB.NET | 2 | 02-01-2007 08:18 AM |