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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-09 : 09:23:48
|
| Suman writes "Source - 18 flat filesIntermediate database - 18 tablesDatawarehouse - 2 fact table(48 columns) - 7 dimension tablesDimension tables are small and the fact table is largeEach fact table column has atleast calculations from four other columns (Using vbscript) on an average from tables in the Intermediate database.Therefore, the time for the transformation increases as and when the no of columns are introduced into the fact table.Testing for the first 183 rows into the fact table takes 18 minutes. If i put the the realtime data the transformation dosent happen and nor does SQL hang.NOW - Do not ask me to do all that mentioned below -http://www.sql-server-performance.com/dts.aspbecoz i have already tried em.Can someone please suggest me a better and sturctural solution.Thanks in advance,Suman." |
|
|
|
|
|
DTS performance optimization