Answer Posted / vensh
Dimension table is nothing but a table which contains detailed description about the data except any values...
Fact table mainly contains the facts nothing but the values that is related to the data in the dimension table and by using the primary key in dimension table and the foreign key in the fact table we will map the dimensional table and the fact table
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
what is an use case?
Explain what are the different types of join operations?
What is data warehouse architecture?
Explain reference cursor?
Explain the versions of reportnet?
What is surrogate key? Where we use it?
What are data modeling and data mining? Where it will be used?
Explain what are the various transformation available?
Explain ddl (data definition language)?
What does level of granularity of a fact table signify?
Explain can report net connect multiple datasource at a time in report creation time?
What are the different types of scd's used in data warehousing?
What is Operational Data Store?
What are cluster analysis in data warehousing?
What is vldb(very large databases)?