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
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Can we create two repositories on same database instance in oracle?
What is rank index in rank transformation?
Explain in detail scd type 2 through mapping.
What is depict expression change?
How many input parameters can exist in an unconnected lookup?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is meant by lookup transformation? Explain the types of lookup transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How can informatica be used for an organization?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is repository manager?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
4 yrs etl devloper roles and responsibilities?any body give solutions
How we can create indexes after completing the load process?
