gupta.sreekanth (1/12/2011)
i,can any one help me in populating time dimensions in sql from 2000 to 2030 for every 15 min.now i need to create time dimensions from 2000 jan 01 to 2030 dec 31 by taking 15 min interval,for every day 96 rows will come.it has to done through ssis(sql server integration services)but not through stored procedures........plz help me if any one know
SSIS is not a data generating tool (at least not out of the box), it is an extraction tool. You can write some TSQL that will generate the data for you and place this in an SSIS package, but then what is the difference between this and stored procedures?
Kimball suggests that you create the date dimensions in a spreadsheet such as Excel and then load this into your data warehouse.
On a side note: wouldn't it be better to create a date dimensions with a grain of a single day and a seperate time dimension to list the time of day?
The grain of this time dimension can be as low as a second, or a minute or if you want, 15 minutes.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP