Explain swot analysis?
Explain me what are conformed dimensions?
Which columns go to the fact table and which columns go the dimension table?
What is fact less fact table? Where you have used it in your project?
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?