April 6, 2010 at 1:02 pm
Hi
I want to build a datawarehouse from a database using SSIS.If anyone knows the procedure could u please let me know. It very urgent.
I really appreciate your help.
Thank you
April 6, 2010 at 1:27 pm
No one is really going to be able to answer that for you. People's entire careers are based on how to design and load data warehouses. Sadly, the industry, in general, has bought into marketing rather than fundamental understanding of database principles. About all I can say to you is, make sure you understand the basics, then work your way up. To start with you should read and understand An Introduction to Database Systems. Once you have read that you could move on to understanding temporal data. As it turns out Date, et el, also has a good book on the topic called: Temporal Data & the Relational Model. However, it is also academic in nature, so you need to need to extrapolate that information into practice for the particular DBMS you are using.
I wish you luck!
April 6, 2010 at 1:42 pm
Very urgent???
Do you need to build your data warehouse today?
April 6, 2010 at 1:57 pm
yes i have to do it today
April 6, 2010 at 2:25 pm
If you have an existing database you already have a Datawarehouse. It is just not what traditional BI or datawarehouse people would consider a datawarehouse. Almost all reporting done with a DW as a source can be done from an OLTP system as well, just not always as elegantly or usually as quickly as a well built DW.
A traditional DW is pretty heavily de-normalised, and as referenced above has temporal data and components added to it to make time based and other queries easier.
Good luck.
April 6, 2010 at 2:41 pm
Assignment is due today?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 6, 2010 at 3:23 pm
yes sir. Actually i have to take a table from adventureworks and create staging tables for it and then load into adventureworksdw and also i should identify facts and dimensions in that table
April 6, 2010 at 3:34 pm
So, what school is this from? What have you been taught so far on this subject? I don't want to waste my, or anybody else's, time by repeating something you already know.
FYI, please do not PM me or anybody else asking for more help. That is not appreciated by most of us here.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
April 6, 2010 at 3:48 pm
Most courses will step you through the process and give instruction on how to do it. I find it intriguing that this project is due today and you don't know what to do with it yet.
Can you provide to us what you have done?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 6, 2010 at 4:27 pm
talktome_nani (4/6/2010)
yes sir. Actually i have to take a table from adventureworks and create staging tables for it and then load into adventureworksdw and also i should identify facts and dimensions in that table
The AdventureWorksDW and AdventureWorksDW2008 samples are available for download here:
April 6, 2010 at 6:45 pm
It would seem that DBCC TIMEWARP would help here. 😉 Bits 69 and 77 need to be set for this one.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply