what is fact and what types of fact tables is there
- 4 Answers
- 9640 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Fact: It is an object that is being analyzed.
Fact table: It consists of a composite key and facts, where ever attribute of the composite key is a foreign key to the dimension table or summarized information.
Two Types Of Fact Tables:
1) Cumulative Fact Table: Describes what was happened over the period of time. They contain addition facts.
2) Snap shot Fact Table: Deals with the particular period time. They contain non-additive and semi-additive facts.
| Is This Answer Correct ? | 3 Yes | 0 No |
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 |
How the informatica server increases the session performance through partitioning the source?
How do you load alternate records into different tables through mapping flow?
What is metadata reporter?
can we use bulk loading when we use look in mapping
What is the function of aggregator transformation?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
Why is sorter an active transformation?
Explain what transformation and how many are there in informatica?
what is the difference between copy object import objects using repositery manager which one is best
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
What are active transformations? Name them.
how to load only the first and last record of a flat file into the target?
Teradata 
