what is fact and what types of fact tables is there
Answer Posted / chandrasekar
A Fact table contains unique combination of dimensional keys.
Fact tables are normalized.
A Fact tables have the facts at the lowest level of granularity.
Types of Fact table:
There are 3 types .
1)Detailed Fact table
2)Aggregate/Summarize fact table
3)Factless fact table
If it wrong means please send the correct answer to me
chandranmca2007@gmail.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you mean by blocking transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to go to the older version for a mapping?
What are ETL Tools?
What is main use of mapplet?
What are the mapping parameters and mapping variables?
Is it possible to revert a global repository to local one and why?
Define filter transformation?
Explain the etl program with few examples.
How would you copy the content of one repository to another repository?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How many dimensions are there in informatica?
Where do we use mapping variables in informatica?
What is mapping debugger?
What is InformaticaPowerCenter?