Hi Every One,What is Use of Factless Fact Table ?
Why we use Factless Fact Schema in the Projects
waiting for reply? thank you

Answer Posted / eswar

Afact table that has no facts but captures certain many-
to-many relationships between the dimension keys. Most
often used to represent events or provide coverage
information that does not appear in
other fact tables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does update strategy mean, and what are the different option of it?

695


Write the advantages of partitioning a session?

852


Please let me know how to make Data masking in informatica..

1343


Separate from a database, an information bazaar, and an information stockroom?

701


What are the advantages of using informatica as an etl tool over teradata?

663






What are Dimensional table?

691


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1828


As union transformation gives UNION ALL output, how you will get the UNION output?

730


According to his methodology what all you need before you build a datawarehouse

1290


What is the session task and command task?

689


What is status code in informatica?

681


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1602


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5447


hi real timers . iam waiting for ur reply regarding ETL TESTING

1909


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1947