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

Factless Fact is having only dimensionla keys with no
measures.Its basically only to get information and no
calculations involved.
For eg:how many no. of Policy closed last month

we might say Factless Fact Table basically used to support
negative analysis report

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In informatica workflow manager, how many repositories can be created?

780


What is mapplet in informatica?

594


Is there any way to read the ms excel datas directly into informatica?

550


what is index?how it can work in informatica

1584


How big was your fact table

1316






Differentiate between sessions and batches?

572


How to do unit testing in informatica? How to load data in informatica ?

651


What is flashback table ? Advance thanks

1481


Define sessions in informatica etl?

617


What is informatica?

680


What is standalone command task?

711


Explain the etl program with few examples.

548


What is Data Caches size?

654


How to elaborate tracing level?

687


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1697