-----------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
----------------Describe DWH Architecture?
What is meant by junk dimension?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
how you provide security to reports? How you provide security to packages ?
What is the deployment requirements used in cognos?
What you mean by drill across and what is the difference between drill through, drill across?
how u will determine the performence tune will occur either in report or system
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
How can create users and permissions in cognos?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
----------------Diff b/w Dimensional modeling and Relational modeling?
Define the slice and dice?
What is the size of the cube?
What is meant by drill down?
Explain what is the main advantage of impromptu over cognos reportnet?