Explain difference between view and materialized view?
No Answer is Posted For this Question
Be the First to Post Answer
Is there any default username & pwd for bo designer & supervisor?
explain about dirty dimension?
Explain what is type 2 version dimension?
What is the use of dimensional modeling in data warehousing?
1.WHAT IS DATA MART ?
Explain what are the methodologies of data warehousing?
Give some difference between oltp and olap.
Explain what are the various file formats involved in reportnet?
if we increase the number of dimensions will the rows in fact table increase or decrease??
Explain what are the different methods of loading dimension tables?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is prompt types of prompts?use of prompts syntax of prompt?