Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
- 1 Answers
- 1031 Views
- I also Faced
- E-Mail Answers
Answer / Rina Kumari
Semi-additive and factless facts are special types of data that cannot be easily aggregated across all dimensions in a multidimensional data model. Semi-additive facts can be aggregated only along certain dimensions (e.g., time) and remain constant for other dimensions, while factless facts have no numeric values but provide additional contextual information (e.g., a flag indicating whether a customer is a VIP). These types of facts are used in scenarios where traditional fact tables may not be sufficient to represent the complexity of the business requirements or data relationships.
| Is This Answer Correct ? | 0 Yes | 0 No |
Is there any difference in testing database and data ware housing?
What are components of report studio?
What is Bulk Insert?
What is data merging, data cleansing and sampling?
When should you use a STAR and when a SNOW-FLAKE schema?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
how to find unique records in informatica level
I need to set predefined condition. How I do this?
What is the capacity of power cube?
What is the main difference between inmon and kimball philosophies of data warehousing?
What is the definition of cube in datawarehousing?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
Teradata 
