What is Factless fact table ???

Answer Posted / aneesh

A factless fact table is fact table that does not contain
fact.They contain only dimesional keys and it captures
events that happen only at information level but not
included in the calculations level.just an information about
an event that happen over a period.
Refer the below site to get a better idea

dwhlaureate.blogspot.in/2012/08/factless-fact-table.html

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is status code in informatica?

582


What are the popular informatica products?

646


How many types of sessions are there in informatica.please explain them?

674


What is an aggregator transformation?

613


what is $$$$?

1734






How do you remove duplicate records in informatica? And how many ways are there to do it?

711


What are the different types of repositories created using informatica?

653


Briefly explain the aggregator transformation?

589


What are the different clients of powercenter?

594


4 yrs etl devloper roles and responsibilities?any body give solutions

1569


What is workflow? What are the components of the workflow manager?

635


How many dimensions are there in informatica?

623


What is a filter transformation?

563


What are active and passive transformations?

647


What is informatica powercenter repository?

709