Answer Posted / y.nagendra reddy
A DIMENSION WHICH IS CHANGED OVER A PERIOD OF TIME IS CALLED
AS A SLOWLY CHANGING DIMENSION OR SLOWLY GROWING DIMENSION.
THERE ARE 3 TYPES.
1.SCD TYPE1:IT STORES ONLY CURRENT DATA.
2.SCD TYPE2: IT STORES HISTORICAL DATA.
3.SCD TYPE3: IT STORES CURRENT AND PREVIOUS DATA.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the deployment requirements used in cognos?
What are all the types of report?
what is the difference between native sql and cognos sql?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
How to create a cube in Transformer? What is the process? Please mention process thank u
What is the difference between static and dynamic conditions?
How to select multiple values from type-in prompt?
What is called materialized view?
How we check the errors before running the report?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What is a Query Subject?
-----------------What is Direct and Conventional loading?
What is called Cognos powerplay?