-----------Types of Fact Tables?
Answer Posted / sharath.dwh
THERE ARE 3 TYPES OF FACTS
1)ADDTIVE:FACTS THAT CAN BE SUMMED
2)SEMI ADDITIVE:FACTS THAT CAN BE SUMMED UP FOR SOME OF THE
DIMENSIONS AND NOT OTHERS.
EX:BANK BALANCE
3)NON ADDITIVE:CAN'T BE SUMMED.
EX:RATIO,AVG,VARIANCE
| Is This Answer Correct ? | 28 Yes | 8 No |
Post New Answer View All Answers
What are the considerations regarding performance kept in mind while setting up cognos?
Explain informatica architecture?
How to join multiple db in catalog?
What is the use of powerhouse?
Can you explain a cognos controller?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
what is catalog and types of catalogs in cagnos and which is better?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
what is log in cognos?
What is difference between informatica power mart and power center?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
What is meant by junk dimension?