Answer Posted / p.suneetha roy
A central table in a data warehouse schema that contains
numerical measures and keys relating facts to dimension
tables as primary key present in Fact table for the
uniqueness and foriegn keys coming from dimension tables
referring to fact table. Fact tables contain texture data
and section.
There are 4 types of facts :
1)Additive
2)Non Additive
3)Semi additive facts
4)Factless fact.
Let me know if there are any more facts.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the function of union transformation?
How does the aggregator transformation handle null values?
What is an aggregator transformation?
What is the different lookup cache(s)?
Performance tuning in UNIX for informatica mappings?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is rank transformation in informatica
Define mapplet?
waht type of interface is used for testing the data in informatica
Can u generate reports in Informatica?
Enlist the tasks for which source qualifier transformation is used.
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the difference between Active and Passive transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
what are the Methods For Creating Reusable Transformations?