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
what is the complex transformation you used in informatica
How many number of sessions can one group in batches?
How you prepared reports for OLAP?
Make a note of the quantity vaults made in informatica?
Explain what are the different versions of informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How might one distinguish in the case of mapping is right or not without associating session?
What is a dimensional model?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is difference between a gateway node and worker node?
What differs when we choose the sorted input for aggregator transformation?
How can we handle two sessions in informatica?
How to differentiate between the active and passive transformations?
What does cheating measurement mean?