Explain what is the difference between power center & power mart?
No Answer is Posted For this Question
Be the First to Post Answer
Why is dimensional normalization not required?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.
Give some difference between oltp and olap.
what is difference between drill & scope of analysis?
How do we design a universe?
What are data validation strategies for data mart validation after loading process?
Explain what are the different types of data warehousing?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What are Data Marts?
What are aggregate fact tables ? why they are needed? give an example
what is parallel query?