Why should we use data ware housing and how can you extract data for analysis with example?
TCS,
996Post New Data Warehouse General Questions
What are the fundamental elements of the data warehouse?
What is a hash cluster?
What are modeling tools available in the market?
Difference between e-r modeling and dimentional modeling?
Why is business intelligence (bi) important in data warehousing?
What is a view as it relates to system modeling?
Ist the schema that a data warehouse system can implements.
What is data stream and data adaopter. Is it same are different? Explain?
What are the other names given to data warehousing?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is data mart in data warehouse?
What is drilling across?
How to load the time dimension?
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?
What is a full backup?