Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ashok kumar lenak
Dimension Table-The tables through which i can under the
business.
It has wide range of rows.
It is called end dimension table.
It is joined to the Fact table.
Values are textural in nature.
Usually the Master tables are look like the Dimention table.
Fact Table-It is also called the Central table.
Most rows are numeric in nature.
Narrow rows and few columns.
It is accessed by the dimention table.
All the PK of the dimention table is at the fact table.
Usually the transaction tables look like the Fact Table.
| Is This Answer Correct ? | 29 Yes | 13 No |
Post New Answer View All Answers
Why should you put your data warehouse on a different system than your oltp system?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
What function should we use to display the value entered or selected by a user in response to a prompt?
What is the definition of cube in datawarehousing?
How can we do data cleaning?
Difference between cold fusion mx 6 and cold fusion mx 7?
What are the differences between datamart vs. Reporting cube?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What are templates in which way it is help full?
What are the approaches used by optimizer during execution plan?
What is the difference between datawarehouse and bi?
Explain bus schema?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Briefly state different between data ware house & data mart?
What are the data marts?
