A Factless fact table contains only the keys but there is no measures or

What is Factless fact table? In which purpose we are using
this in our DWH projects?Plz give me the proper answer.

Thanks,
Ramesh

Question Posted / samir kumar sahoo

6 Answers
13715 Views
ACS, I also Faced
E-Mail Answers

Answer Posted / samir kumar sahoo

A Factless fact table contains only the keys but there is
no measures or in other way we can say that it contains no
facts.

Generally it is used to intigrate the fact tables.

Is This Answer Correct ?

11 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What we will do with the universe for faster process?

919

Explain what is the difference between powerplay transformer and power play reports?

1065

What is metadata in context of a datawarehouse?

962

Explain the different types of data warehousing?

931

What is loop in data warehousing?

1073

Explain what is the difference between view filter and report filter?

916

What are situations where snowflake schema is better than star schema when the opposite is true?

929

Explain what are the various reporting tools in the market?

914

What is bi?

1012

What is batch processing?

964

What are loops in Datawarehousing?

936

Explain conformed fact?

893

What is latest version of power center / power mart?

986

Explain a relation schema and a relation?

1032

What is the data type of the surrogate key?

926