Explain how are the dimension tables designed?
No Answer is Posted For this Question
Be the First to Post Answer
What is meant by metadata in context of a data warehouse and how it is important?
What is up date strategy and what are th options for update strategy?
Explain what are slowly changing dimensions?
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?
How do you define data block size?
How to answer the question how many fakt table in your datawarehouse and what size it have?
What is difference macros and prompts?
Explain what is the difference between datawarehouse and bi?
What are the design methods of data warehousing?
what is a hot file, why we need in datawarehousing, where we used in general
What are the steps involved in designing a fact table?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.