Interested to Buy Any Domain ? << Click Here >> for more details...
what is fact and what types of fact tables is there
- 4 Answers
- 11224 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 to create the source and target database connections in server manager?
What is the difference between source qualifier transformations source filter to filter transformation?
How to update source definition?
what is INFORMATICA TESTING process
what is the -ve test case in your project.
How to elaborate tracing level?
How is union transformation utilized?
Explain the shared cache and re-cache?
What are the different transaction levels available in transaction control transformation?
What are the prerequisite tasks to achieve the session partition?
To import the flat file definition into the designer where should the flat file be placed?
What is workflow monitor?
What are mapplets?
Write the advantages of partitioning a session?
What is a mapplet/worklet in informatica?
