Explain dimensional modelling?
What is the metadata extension?
Can a dimension table contain numeric values?
Whether dimension table can have numeric value?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
Explain is olap databases are called decision support system true/false?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is an OLAP (On-line Analytical processing) system?
Explain er diagram?
What is the main difference between star and snowflake star schema? Which one is better and why?
Explain what are non-additive facts in detail?
what type of raid setup would you put your tx logs?
What function should we use to display the value entered or selected by a user in response to a prompt?