 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008SSIS
In my envrionment not all the tables have datetime field that indicates when the row is created or updated. Coming up a DW project that will be implemented I would like to ask the community what kind of techniques they use for Incremental data loading. There are some tables that has over 20 million rows that I don't want to do full load. Hi As you are on SQL 2005 you could use table partitions. Your exact solution is very much dependent on the application and system you have for it's design. John > In my envrionment not all the tables have datetime field that > indicates when the row is created or updated. Coming up a DW project > that will be implemented I would like to ask the community what kind > of techniques they use for Incremental data loading. There are some > tables that has over 20 million rows that I don't want to do full load. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.