Interested to Buy Any Domain ? << Click Here >> for more details...
what is fact and what types of fact tables is there
- 4 Answers
- 11387 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
Write the unconnected lookup syntax and how to return more than one column.
wf dont have integration severances how you can run?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What do mean by local and global repository?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How does a rank transform differ from aggregator transform functions max and min?
Why union transformation is an active transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Implementation methodology
What you know about transaction control transformation?
Explain how to import oracle sequence into informatica?
Explain the pipeline partition with real time example?
EXL informatica Questions
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is native users?
