Answer Posted / 19-10-2011
WHICH FACT TABLE DOES NOT CONTAIN THE FACTS IS CALLED AS
FACT LESS FACT TABLE.
| Is This Answer Correct ? | 5 Yes | 13 No |
Post New Answer View All Answers
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.
How to handle multi value dimensions?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
how much memory space occupied real time project (roughly)?
What is the difference between ods and oltp?
What is the 4 + 1 view model as it relates to system modeling?
Tell me what is full load & incremental or refresh load?
Explain the difference between oltp and olap?
Store (and count) non-fact records?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is data analysis? Where it will be used?
What are fundamental stages of data warehousing?
What is the difference between data warehouse and operational systems?
What are the different types of segments?
What is Analysis Services?