Answer Posted / vijay
star schema& snowflake schema.because two schemas are
integrated.
Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
What are partition points?
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.
What is dimension modeling?
Name a few sectors which use data warehousing?
What are the methodologies of data warehousing?
What is surrogate key? Where we use it? Explain with examples.
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Why should we use data ware housing and how can you extract data for analysis with example?
How can we load the time dimension?
What is meant by metadata in context of a data warehouse?
Explain the difference between keylokup and joiner?
What is the definition of cube in datawarehousing?
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?
Describe the differences between a data warehouse and data mart.
Explain what are the vaious etl tools in the market?