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


Please Help Members By Posting Answers For Below Questions

What are target types on the server?

550


Explain dimensional modelling?

542


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?

5262


What is the data type of the surrogate key?

531


Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1557






Explain the definition of normalized and denormalized view?

523


Can you brief about the Data warehouse project you worked on?

1947


How to import vsam files from source to target. Do we need a special plugin?

507


How can we do data cleaning?

584


What is Star Schema?

643


Explain differences between star and snowflake schemas?

532


In document how to create metrics?

553


After we create a scd table, can we use that particular dimension as a dimension table for star schema?

545


Tell me what is degree of a relation?

518


What is Discover and Execute in XMLA?

1781