Answer Posted / pratap gangula
A confirmed dimension is a dimension which can be joined with more than one fact table and can be reused in other data marts as well.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain why are oltp database designs not generally a good idea for a data warehouse?
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.
What are the different types of data warehouses?
What are the types of SCD?
What is Discover and Execute in XMLA?
How to handle multi value dimensions?
What are snapshots? What are materialized views & where do we use them?
Explain what are the vaious etl tools in the market?
Explain the different types of data warehousing?
Explain which columns go to the fact table and which columns go the dimension table?
what is user variable in affinium campaign? and some real time examples.
What are the different types of data warehousing?
What is the difference between filter and lookup transformation?
Explain why should you put your data warehouse on a different system than your oltp system?
What is surrogate key? Where we use it?