Interested to Buy Any Domain ? << Click Here >> for more details...
what is fact and what types of fact tables is there
- 4 Answers
- 11151 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / pawan
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 |
Post New Answer View All Answers
what is song in infrmatica...?
How many number of sessions can one group in batches?
What is an unconnected transformation?
What is the difference between a repository server and a powerhouse?
explain abt ur project architecture?
Explain the code page compatibility?
In how many ways we can create ports?
Performance tuning in UNIX for informatica mappings?
What can we do to improve the performance of informatica aggregator transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is blocking transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are the steps involved in the migration from older version to newer version of Informatica Server?
differences between service based and product based?
