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
Explain difference between powerplay transformer and power play reports?
Which lifecycle we will use for reporting?
What is the difference between set functions and filter function in dimensional data?
what are the errors faced while bursting the reports and how to solve those errors?
Can you define confirmed dimension?
What is the use of Cognos scenario?
What is meant by junk dimension?
how to create cubes in transformer ?
How to create model and how to test model?
where you can save the report net documentation in our local system?
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......
What is the size of database for you project?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What is the use of cognos decision stream?
Can you define folder?