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
- 13988 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
What is an error log table in informatica occurs and how to maintain it in mapping?
What is a Decision Tree Algorithm?
What are situations where snowflake schema is better than star schema when the opposite is true?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What are the different types of join operations?
What is the difference between datawarehouse and bi?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
What are the other names given to data warehousing?
How to define a cube??
in general which algorithms for used?
What are the stages that are required in data warehousing?
What are the different types of schemas used in data warehousing?
How to generate the cubes in framework manager?
For faster process, what we will do with the universe?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
