What are non-additive facts in detail?
No Answer is Posted For this Question
Be the First to Post Answer
Why should you put your data warehouse on a different system than your oltp system?
Compare aggregates and data marts
Explain dimension table ?
What should I have in mind when building olap solution from scratch?
What is static and local variable?
what are different storage options supported by oracle ?
what is difference between scd2 and scd3
what role views play in dimensional modeling?
What is the difference between aggregate table and materialized view?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What is staging area?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?