How to answer the question how many fakt table in your
datawarehouse and what size it have?
Answer Posted / gopal
There are 3 fact tables
Cumulative
Snapshot
Fact less fact table
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
Explain what are the steps to build the data warehouse?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
How are the dimension tables designed?
What is the difference between a primary and secondary actor in use case modeling?
What are snapshots? What are materialized views & where do we use them?
Explain what is type 2 version dimension?
What is an er diagram?
What is the difference between ods and oltp?
Which columns go to the fact table and which columns go the dimension table?
What is crass reference table?
What is a data profile?
Why denormalization is promoted in universe designing?
What is surrogate key? Where we use it explain with example?
What are the steps involved in designing a fact table?
What is an error log table in informatica occurs and how to maintain it in mapping?