What is pre-emptive and non-pre-emptive?
Explain what does level of granularity of a fact table signify?
What is ods (operation data source)?
What is data validation strategies for data mart v?
Explain what are fact, dimension, and measure?
Explain why denormalization is promoted in universe designing?
What is latest version of power center / power mart?
What is partitioning? What are the types of partitioning?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What is an er diagram?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
Explain why should you put your data warehouse on a different system than your oltp system?
What is the difference between ods and oltp?
Explain difference between view and materialized view?