-----------Types of Fact Tables?
Answer Posted / vishwamithra
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
------------------------------------------------------------
----------There are two types of Fact Tables namely :
1) Cummulative Fact Table : Facts collected over a period
of time are called CFT.
2) Snapshot Fact Table: Facts collected at adhoc basis are
called SFT.
-----------
Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate Why need staging area database for dwh? Name the types of report? What is defined as catalog and types of catalogs in Cognos? What is cognos reporting tool? What is the function of model design accelerator? I have ten columns that needs to be totalled...
but some columns are empty...how do i get sum all the
columns even if sum are empty?
Can i get a total of the rows instead of columns? if yes,
what is the function to be used? Explain informatica architecture? what are the dimensions that you have in your current
project?list them? How can create users and permissions in cognos? What are all the components of Report Studio? What is drill down and slicing and dicing whats the difference between them? What are all the types of report? -------------How you design DWH? can anyone provide link to download cognos 7.2 version for
download along wiht installation and configuration steps tx
in advance