Interested to Buy Any Domain ? << Click Here >> for more details...
What is Factless fact table? In which purpose we are using
this in our DWH projects?Plz give me the proper answer.
Thanks,
Ramesh
- 6 Answers
- 14170 Views
- ACS, I also Faced
- E-Mail Answers
Answer Posted / asish
factLess fact table def as mentioned above..
Where it is used?
These are used particularly to resolve many to many
relationships,which will create duplicate counts in OLAP
Cube creation.
Or it can be used to avoid loops which will decrease the
query performnce while reporting
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
Explain where do we use semi and non additive facts?
What is the difference between filter and lookup transformation?
What is analytical or analytic mean?
Explain multivalued dependency?
What is critical column?
What is the very basic difference between data warehouse and operational databases?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is the difference between mapping parameter & mapping variable in data warehousing?
Explain me what are conformed dimensions?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What is metadata in context of a datawarehouse?
What is the difference between datawarehouse and bi?
What is the main difference between inmon and kimball philosophies of data warehousing?
