Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-05-02 : 02:55:15
|
| Hi All,I have question on which one would be the best methods for Loading into DW.Method:1Truncate the Entire Target Table and Load it from scratch???Method:2Going for Incremental Loads.What are the Different factors we consider the best loading method???Thanks, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-02 : 09:44:05
|
| it depends on how large table is and amount of other processes involved for table population like lookups etc. In case where data is large and growth is large you go for incremental loads while in case of small tables you go for truncate and repop. Also in cases where you want to store cumulative aggregate data latter method is best while for snapshot tables initial.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Choose best method for loading DW