Can you brief about the Data warehouse project you worked on?
Explain what is a three tier data warehouse?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
I know of using applysimple, but there are other ways too?
What is ods (operation data source)?
Explain what is the difference between stop and abort?
How to calculate fact table granularity?
Why is business intelligence (bi) important in data warehousing?
What are the different types of fact tables used in data warehousing?
What is the purpose of cluster analysis in data warehousing?
Explain what are slowly changing dimensions?
What is data mart in data warehouse?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
Who needs data warehousing?
Tell me what is degree of a relation?