Explain what are the modules in power mart?
Explain what is ods (operation data source)?
Explain difference between data ware house & data mart?
Explain what is the difference between view filter and report filter?
What is data type of the surrogate key?
Where the applications and where ware house management system is used?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What is the difference between power center & power mart?
Explain what are conformed dimensions?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
How to calculate fact table granularity?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
what type of raid setup would you put your tx logs?
What is a general purpose scheduling tool?
What is the metadata extension?