Explain the difference between data ware house & data mart?
After the complete generation of a report who will test the report and who will analyze it?
What is the difference between snowflake and star schema?
Explain the importance of data warehouse?
How can we run the graph? What is the procedure for that?
What is a source qualifier?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
What is difference between e-r modeling and dimensional modeling?
What is a hash cluster?
What is data analysis? Where it will be used?
What are the methodologies of data warehousing?
What is the difference between dependent data warehouse and independent data warehouse?
What is the difference between aggregate table and materialized view?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.