Basics - Which columns go to the fact table and which columns go the dimension table

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 23 of 113

Which columns go to the fact table and which columns go the dimension table

Answered by Satish on 2005-04-29 08:20:29: The Aggreation or calculated value colums will go to Fac Tablw and details information will go to diamensional table.

Total Answers and Comments: 3

Last Update: March 09, 2006

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

April 29, 2005 08:20:29

Satish

RE: Which columns go to the fact table and which columns go the dimension table

The Aggreation or calculated value colums will go to Fac Tablw and details information will go to diamensional table.

Is this answer useful? Yes | No

August 03, 2005 20:16:15

sudhir

RE: Which columns go to the fact table and which columns go the dimension table

To add on Foreign key elements along with Business Measures such as Sales in $ amt Date may be a business measure in some case units (qty sold) may be a business measure are stored in the fact table. It also depends on the granularity at which the data is stored

Is this answer useful? Yes | No

March 09, 2006 00:57:43

ravi kumar guturi

RE: Which columns go to the fact table and which colum...

Before broken into coloumns is going to the fact

After broken going to dimensions

Is this answer useful? Yes | No

0 1

Overall Rating: -1

Go To Top

User Name		Remember Me?
Password

Question Bank