What is your spectra photometer working principles?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
What is the data type of the surrogate key?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is difference between e-r modeling and dimensional modeling?
Explain the importance of data warehouse?
Whether dimension table can have numeric value?
What is dimensional modelling?
What is the differences between star and snowflake schemas?
Difference between e-r modeling and dimentional modeling?
What is the advantages data mining over traditional approaches?
What is drill-through?
Ist the schema that a data warehouse system can implements.
Explain what are the different types of data warehousing?
Explain what are the possible data marts in retail sales?