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 / asha
2 purposes of factless fact
1. Coverage : to indicate what did NOT happen. Like to
answer questions like which product did not sell well in a
particular region.
2. Event tracking: To know if the event took place or not.
Like: Fact for tracking students attendence will not
contain any measures.
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How to pivot row data using informatica?
What are situations where snowflake schema is better than star schema when the opposite is true?
What is the goal of optimizer?
How can we schedule the graph in unix?
Explain which columns go to the fact table and which columns go the dimension table?
What is incremintal loading?
What are components of reportnet?
What is difference macros and prompts?
What is the difference between metadata and data dictionary?
What is mean by aggregate aware?
Can any one explain the hierarchies level data warehousing.
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What are the steps involved in creating dimensional modeling process?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.