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
How do you create surrogate key using ab initio?
How to join 3 database like flat file, oracle, db2 in informatrica?
Which are the olap tools available that are supported by oracle?
Explain the structure of cold fusion?
What is the data type of the surrogate key?
What are the types of partitioning?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain the main difference between inmon and kimball philosophies of data warehousing?
How to import vsam files from source to target. Do we need a special plugin?
How to calculate fact table granularity?
What are diagrams?
Explain what are the different types of data warehousing?
What is difference between model & package?
Explain what is the difference between view filter and report filter?
What are snapshots? What are materialized views & where do we use them?