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 normalization?
what are the other factors of the database on which the loading performance depend?
What are the types of SCD?
What is fact less fact table? Where you have used it in your project?
What is conformed fact?
Explain what is batch and describe about types of batches?
How to eliminate duplicate rows from flat file?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What is the purpose of cluster analysis in data warehousing?
Explain ddl (data definition language)?
Do you view contain data?
What is the main difference between star and snowflake star schema? Which one is better and why?
Explain what are the various transformation available?
What does level of granularity of a fact table signify?
Suppose we want to display zero when null values coming to report how can we do that?