What is Factless fact table? In which purpose we are using
this in our DWH projects?Plz give me the proper answer.
Thanks,
Ramesh
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 are the key features of chameleon that separates it from other algorithms?
What is mean by aggregate aware?
How to generate iqd file from framework manager?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
What is the difference between datawarehouse and bi?
what are the other factors of the database on which the loading performance depend?
Which are the olap tools available that are supported by oracle?
What is a Decision Tree Algorithm?
Explain me what are data marts?
In document how to create metrics?
What are snapshots? What are materialized views & where do we use them?
what are relationships?
Explain er diagram?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
what is user variable in affinium campaign? and some real time examples.