Answer Posted / suren
Fact table contains measurement of information
Factless table contians with out any measure.
1.Additive : Additive fact table contains the summarized
data.
2.Non Additive : Non Additive fact table contains without
additve data.it contains only detail data
3.SemidAdditive: Semi additive fact table contains both the
summarized data as well as detial data
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define sessions in informatica etl?
What is the fact table?
Explain about cumulative Sum or moving sum?
Mention a few design and development best practices for informatica?
What are pre and post-session shell commands?
Why update strategy and union transformations are active?
What are the types of lookup transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Performance tuning in UNIX for informatica mappings?
explan ur project architecture?
Can we get 1st record through Informatica(without sequence number).
How would you copy the content of one repository to another repository?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is the difference between source qualifier transformations source filter to filter transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?