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 is index awareness in universe?
What is edw?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
What is core dimension?
Explain what are the modules in power mart?
Define data warehouse?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What is the difference between er modeling and dimensional modeling?
Tell me what is full load & incremental or refresh load?
What is a core dimension?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How can you clear the cache?
What is Active Datawarehousing?
What is metadata in context of a datawarehouse?
How to drill through from a powerplay cube to reportnet?