Factless fact tableis used for the converting the star schma into snowfl

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 / eswar

Answer Posted / eswar

Factless fact tableis used for the converting the star
schma into snowflake schema

Is This Answer Correct ?

0 Yes

14 No

Please Help Members By Posting Answers For Below Questions

I have two universes created by two difference database can we join them in designer & report level? How

1035

What is latest version of power center / power mart?

1143

Explain what are the possible data marts in retail sales?

1053

How we are using this function?

1185

What is fact less fact table? Where you have used it in your project?

1079

How to drill through from a powerplay cube to reportnet?

989

Name a few sectors which use data warehousing?

983

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?

5703

How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

1051

Explain what is full load & incremental or refresh load?

1028

What is recovering sessions?

995

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1042

What is the use of incremental aggregation? Explain me in brief with an example?

1075

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

997

Explain a linked cube?

994