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
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Can any one explain the hierarchies level data warehousing.
Tell me what is full load & incremental or refresh load?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
What we will do with the universe for faster process?
What is analytical or analytic mean?
What are algorithms provided by Microsoft in SQL Server?
What is the 4 + 1 view model as it relates to system modeling?
What are components of reportnet?
What are the stages that are required in data warehousing?
How to export mappings to the production environment?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What is degenerate dimension table?
Explain what are the methodologies of data warehousing?
