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.

All Forums  General SQL Server Forums  Database Design and Application Architecture  DWH SSIS design

Author  Topic  Linda Starting Member 1 Post Posted - 2011-04-15 : 02:55:37 Hi all, i need your help regarding some issues i faced recently. i work for a big company which our DWH is around 2Tera. right now the daily proccess is like this package 1 - reading from the systems. p2 - build dims.(around 28 dims) p3 - Build facts. (around 20 facts) p4 - Audit Dims p5 - copy to DWH layer p6 - proccess cubes everything right now is in one solution, and since we have so many facts and dims its realy hard to follow each package. my questions: 1. what is the best practice for designing ssis packages? is it better to put all the facts at one package or i should split it.(same question for the dims). does it better to run seperate packages for each bussiness model(costs, hr, orders etc) or should i do it together parallel at one package? 2. regarding the audit, can i call it few times at the proccess or should i do it only once , like it is right now? 3. what is the best practice for dwh Audit step, what should it do?