what is fact and what types of fact tables is there
- 4 Answers
- 9662 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 is a transaction control transformation?
What is rank transformation?
which one is better performance wise joiner or look up
How can one identify whether mapping is correct or not without connecting session?
How many types of sessions are there in informatica.please explain them?
have u done any performance tuning? how u ll do?
Explain your project of banking domian.
How many ways are there to create ports?
How do you take back up of repository?
What do you mean by channel change?
What differs when we choose the sorted input for aggregator transformation?
What is the Rank index port in Rank transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is the command used to run a batch?
Which means the first record should come as last record and last record should come as first record and load into the target file?
