Explain what is partitioning? What are the types of partitioning?
What is meant by metadata in context of a data warehouse and how it is important?
What are the various tools? Explain name a few?
What is the capacity of power cube?
What is the difference between view materialized view and view?
What are the approaches used by optimizer during execution plan?
What are the differences between star and snowflake schema?
What is Snow Flake Schema design in database?
explain about balanced dimension,
Explain why denormalization is promoted in universe designing?
What is data stream and data adaopter. Is it same are different? Explain?
What is the difference between view filter and report filter?
Hierarchy of DWH?
2 Answers Accenture, EDS, IBM, iFlex, TCS,