Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Every One,What is Use of Factless Fact Table ?
Why we use Factless Fact Schema in the Projects
waiting for reply? thank you
- 6 Answers
- 14778 Views
- I also Faced
- E-Mail Answers
Answer Posted / purnima
to combine two diffeerent diminsions information we use
fact less fact table.
for ex:if we want to get deatails about a promotion
information like when it is lauched.we will get that
information from promotion dimensions and time
dimension ,so in this scenerio there is no need of any fact
information but we need data from thes two dimension then
we go for factless fact table
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How are the sources and targets definitions imported in informatica designer?
What is difference between a gateway node and worker node?
Can u generate reports in Informatica?
Explain Dataware house architecture .how data flow from intial to end?
How would you join a node to the already existing domain?
What is dimensional table? Explain the different dimensions.
tell me about your project functionality
Is there any way to read the ms excel datas directly into informatica?
What is a filter transformation?
How many number of sessions can one group in batches?
How we can use union transformation?
How to elaborate tracing level?
What is workflow? What are the components of workflow manager?
How do you change a non-reusable transformation to reusable transformation?
