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
What is aggregator transformation in informatica?
What is the use of an aggregator cache file?
What is meant by lookup transformation? Explain the types of lookup transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is rank transformation?
What are the different versions of informatica?
What is primary and backup node?
What are roles and groups and benefits of using them?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Performance tuning( what you did in performance tuning)
what are 3 tech challenges/ common issues you face?
How will the document be delivered to me?
What do you mean by channel change?
To import the flat file definition into the designer where should the flat file be placed?
What is meant by active and passive transformation?