what is slowly growing dimension??

Answer Posted / naresh

slowly changed/growing dimentions are 3 types

scd1 : it displays only current information it does not
display any historical infomation.

scd2 : it displays current + Historical information(full
histiry)

scd3 : it displays partial historical information not full
history
ex: bank mini statements last 10 trasactions

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the difference between ‘macros’ and ‘prompt’?

609


How to a create header dynamically in a crosstab report in cognos 8.1?

1991


What is difference between data mart and data warehouse?

549


What is difference between primary key and unique key constraints?

570


-----------Diff b/w OLAP and RDBMS?

1623






how to perform single sign in cognos by using url?

570


what is the difference between filter and condition?

610


How can I schedule reports in cognos?

604


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?

1549


how you provide security to reports? How you provide security to packages ?

641


What is dtm?

722


What do you understand by ‘ibm predictive maintenance and quality’?

569


Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

651


what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us

2548


what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

1883