Interested to Buy Any Domain ? << Click Here >> for more details...
what are the types of facts ? explain them?
- 2 Answers
- 23132 Views
- Business Objects, Informatica, Syntel, Teradata, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / palzkumar
Three types of Fact...
1. Additive Fact: Additive facts are facts that can be
summed up through all of the dimensions in the fact table.
2. Semi-Additive Fact: Semi-additive facts are facts that
can be summed up for some of the dimensions in the fact
table, but not the others.
eg : Bank Balances - you can take a bank account as Semi-
Additive since a current balance for the account can't be
summed as time period; but if you want see current balance
of a bank you can sum all accounts current balance.
3. Non-Additive Fact: Non-additive facts are facts that
cannot be summed up for any of the dimensions present in
the fact table.
Eg: . Ratios, Averages & Variance
rgds,
palz
| Is This Answer Correct ? | 47 Yes | 1 No |
Answer / arkchowdary
Types of Facts------------------ Additive Fact,
Semi-Additive Fact,
Non-Additive Fact.
Perodic Fact,
Accumilative Fact
| Is This Answer Correct ? | 10 Yes | 8 No |
17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?
Why need staging area database for dwh?
How we check the errors before running the report,plz let me know the answer
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
how you create security to reports?
Define query items?
what is Galaxy schema??
can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?
what is prompt variable
how to access the database directly from cognos reportnet
Explain about scorecarding?
What are the types of studio present in Cognos?
Teradata 
