Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
No Answer is Posted For this Question
Be the First to Post Answer
What are algorithms provided by Microsoft in SQL Server?
what is the difference between DSS and ODS ?
what is user variable in affinium campaign? and some real time examples.
What are aggregate tables and aggregate fact tables?
What are the steps involved in designing a fact table?
How much data hold in one universe.
Why denormalization is promoted in universe designing?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Are facts same as metrics and dimensions same as measures? If not , please tell the difference?
Explain how to export mappings to the production environment?
How to handle multi value dimensions?
Explain the difference between filter and conditin?