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
Write various indexes used in cognos?
What is the difference between low affinity and high affinity connections?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
What are initial page components of Cognos connection?
What are the different types of important services used in cognos?
How can create users and permissions in cognos?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
what are slowly changing dimensions? Why we are used scd?
What is the use of Cognos scenario?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
What is the difference between a data mart and a data warehouse?
how can I test reports in cagnos?
What actually a project contains?
What are all the types of report?