Interested to Buy Any Domain ? << Click Here >> for more details...
what is fact and what types of fact tables is there
- 4 Answers
- 11030 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
how tokens will generate?
Difference between Data and Index Caches?
Explain the different lookup methods used in informatica?
What are the new features of Power Center 5.0?
What the difference is between a database, a data warehouse and a data mart?
How can we delete duplicate rows from flat files?
Is it possible to create multiple domains on a single Informatica server?
Explain the types of transformations?
What are the main issues while working with flat files as source and as targets ?
What is a repository? And how to add it in an informatica client?
Can we override a native sql query within informatica?
Explain sessions. Explain how batches are used to combine executions?
What is depict expression change?
What is a filter transformation?
What do think which one is the better joiner or look up?
