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
how to perform single sign in cognos by using url?
What is drill down and slicing and dicing whats the difference between them?
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.
is cognos 7 is better than cognos 8
What is a dimension?
in u r data u having duplicates how to fetch the latest data in our report?
4. How many dimensions did you use in your reports?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
9. What was the most complex type of report you dealt with?
what is a prompt value in report studio and variables ?
What is Online View?
Can you define report item?
--------------Diff b/w ODS and OLAP?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
Why is auto-regression used in forecasting used on cognos platform?