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
- 13717 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 difference between olap and datawarehosue?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
what are different storage options supported by oracle ?
Explain what is a view as it relates to system modeling?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is the definition of cube in datawarehousing?
Explain reference cursor?
Explain grouped cross tab?
Is there any difference in testing database and data ware housing?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Describe the differences between a data warehouse and data mart.
What is the metadata extension?
Suggest a good author for hyperion in data warehousing?
Explain a linked cube?
What is the difference between connected and unconnected stored procedures?
