question

Sibusiso avatar image
Sibusiso asked

T-Sql Command

HI Guys, I'm a BI/DW intern. I would like to create a DW with four dimension which are Customer Dim, Date Dim, Time Dim with a Customer(SCD)Type1 and Type2 can you please help with the Attributes and the T-Sql code as well.
t-sql
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

The attributes are the things that you want to report on - only you can answer that
2 Likes 2 ·
As an intern, this is an outstanding opportunity to ask these questions of the senior people you are working with. They will probably appreciate your curiosity and willingness to learn and, more importantly to you, you will learn which attributes are important for this business to report on and why they are important. BI solutions are about so much more than just the technical know how. You really have to help the business discover which bits of information are critical to their decision making and why that information is important. Take full advantage of this chance to acquire these discovery skills.
1 Like 1 ·
This web site runs off of votes. Can you please indicate all helpful answers below by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate that by clicking on the check mark next to that one answer.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
The T-SQL syntax is a combination of [CREATE TABLE][1] and [ALTER TABLE][2] to add foreign key constraints. But I can't give you any details because I don't know what columns you need to add to those tables, you do. [1]: http://msdn.microsoft.com/en-us/library/ms174979.aspx [2]: http://msdn.microsoft.com/en-us/library/ms190273.aspx
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jimhorn avatar image
jimhorn answered
For the date dim I have an article on [Build your own SQL calendar table to perform complex date expressions][1] with executable T-SQL to create that table. You'll need to provide us more details on the other tables. [1]: http://rdsrc.us/JjgtyE
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.