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
What are the possible data marts in retail sales?
What are partition points?
What is a full backup?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
Is there any default username & pwd for bo designer & supervisor?
Which are the olap tools available that are supported by oracle?
What is the difference between er modeling and dimensional modeling?
How can you set the session management?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Explain difference between data ware house & data mart?
How to create diff. Types of templates?
How are the dimension tables designed?
Explain what is cost benefit analysis (cba)?
What are data modeling and data mining? Where it will be used?
What are various warehousing tools?
