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 / 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
What is the Process to creating lookup transformation in informatica
What is primary and backup node?
Where are the source flat files kept before running the session?
what is informatica metadata?
What is the difference between Active and Passive transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Reusable transformation and shortcut differences
While migrating the data from one environment to another environment how would you manage the connections?
can anyone explain me about retail domain project in informatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
To import the flat file definition into the designer where should the flat file be placed?
Explain the scenario which compels informatica server to reject files?
On which transformations you created partitions in your project?
What is a sorter transformation?
What is the session task and command task?