Interested to Buy Any Domain ? << Click Here >> for more details...
what is fact and what types of fact tables is there
- 4 Answers
- 11205 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 are some examples of informatica etl programs?
How to do unit testing in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
can anyone suggest best free Talend data integration training online
How might you approve all mappings in the archive all the while?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is the need of etl tools?
What are the features of complex mapping?
Suppose we do not group by on any ports of the aggregator what will be the output?
have u done any performance tuning? how u ll do?
How does a rank transform differ from aggregator transform functions max and min?
What is an active transformation?
What do mean by local and global repository?
Is it possible to revert a global repository to local one and why?
