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 / pratap gangula
Factless fact table contains only foreign keys. We can have two kinds of aggregate functions from the factless fact one is count and other is distinct count.
Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What are different deliverables according to phases?
How to get the first 100 rows from the flat file into the target?
How do we design a universe?
Explain what is the extension of file to save template?
Compare cold fusion with other programming languages?
How can you communicate with web server (apache or iis) from coldfusion?
Could any one explain me how to create cascading prompts?
What is static and local variable?
Explain reference cursor?
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?
What is Discrete and Continuous data in Data mining world?
What is incremintal loading?
What is the difference between metadata and data dictionary?
Explain the differences between normalizer and normalizer transformation?
What is cfapplication tag?