Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
No Answer is Posted For this Question
Be the First to Post Answer
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
Explain dimension table ?
Explain what is the data type of the surrogate key?
Explain what are the various reporting tools in the market?
what is Materialized Views?
Explain piconet?
How to know the time taken for particular report execution?
Define data warehouse?
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain why dimenstion tables are denormalized in nature?
What is Bulk Insert?
How to define a cube??