What is the metadata extension?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Describe the differences between a data warehouse and data mart.
Explain what is type 2 version dimension?
Explain the definition of normalized and denormalized view and what are the differences between them?
What is defined as partial backup?
Explain er diagram?
Explain about core dimension,
Whether dimension table can have numeric value?
What is real-time datawarehousing?
What is partitioning? What are the types of partitioning?
Explain what are the vaious etl tools in the market?
Explain conformed fact?
What is the function of surrogate key in data warehousing?
What are fact, dimension, and measure?