Interested to Buy Any Domain ? << Click Here >> for more details...
what is fact and what types of fact tables is there
- 4 Answers
- 11015 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
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
what are factless facts? And in which scenario will you use such kinds of fact tables.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain lookup transformation is active in informatica
How do you load only null records into target?
What is the maplet?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
expain about the tune parameters?
How to update source definition?
What is the Process to creating lookup transformation in informatica
lookup transformation with screenshots
how tokens will generate?
Explain lookup transformation in informatica
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is native users?
