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

How does a rank transform differ from aggregator transform functions max and min?

676


How to join three sources using joiner? Explain though mapping flow.

704


How you can differentiate between connected lookup and unconnected lookup?

617


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1563


Separate from an archive server and a powerhouse?

499






What are the types of lookup transformation?

636


How can we update a record in the target table without using update strategy?

659


What is an aggregator transformation?

617


Can we get 1st record through Informatica(without sequence number).

991


What are the performance considerations when working with aggregator transformation?

678


What are the differences between joiner transformation and source qualifier transformation?

631


Explain the different lookup methods used in informatica?

590


What are the tuning techniques you applied during your last project

1567


Why do we need informatica?

555


COM components can be used in Informatica

1877