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 / dirasanchu
It is a fact table which does not contain any measurable data.
EX: Student attendance fact (it contains only Boolean
values, whether student attended class or not ? Yes or No.)
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What are target types on the server?
Explain dimensional modelling?
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 the data type of the surrogate key?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
Explain the definition of normalized and denormalized view?
Can you brief about the Data warehouse project you worked on?
How to import vsam files from source to target. Do we need a special plugin?
How can we do data cleaning?
What is Star Schema?
Explain differences between star and snowflake schemas?
In document how to create metrics?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Tell me what is degree of a relation?
What is Discover and Execute in XMLA?