what is fact and what types of fact tables is there
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 create a non-reusable instance of reusable transformations?
Tell me about MD5 functions in informatica
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is meant by a domain?
Enlist the advantages of informatica.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
what are the deliverables?in your project?
What is meant by LDAP users?
Explain the code page compatibility?
What do you understand by a term domain?
What is the procedure for creating independent data marts from informatica 7.1?
wf dont have integration severances how you can run?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Mention some types of transformation?
How can you increase the performance in joiner transformation?