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 |
|
sidhu
Starting Member
1 Post |
 Posted - 2011-10-03 : 00:47:58
|
| Hello,How to denormalize a database in SSIS. Can you please explain with a example.Thanks in Advancesidhu prasad |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-03 : 01:04:06
|
| what do you mean by denormalising a db using SSIS? have you already designed denormalised tables? Thsts something you need to do first. Then you can use SSIS to populate the denormalised table with required details by using a series of lookups with related tables to get related data. I would recommend doing this in ssis only if dbs are distributed over different servers and also it involves heterogenous sources like excel, flat file etc. Otherwise I will be implementing this through normal stored procedures only in T-sql as thats set based.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Denormalizing a Database