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

What is the difference between a data mart and a data warehouse?

537


Can you explain the advantage of using shortcuts?

603


What errors and types of errors you faced in Cognos ReportNet?

3472


What is the function of model design accelerator?

531


what are the special features in cognos reportnet?

605






is cognos 7 is better than cognos 8

1684


Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

1616


New coloums are added in database, then how you know in report level

1148


i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1544


Can you define drill down and drill up?

626


What is the function of cognos dispatcher?

582


How is possible this scenario using in type-in prompt.?

580


What do you understand by the cognos?

535


What is difference between informatica power mart and power center?

556


Explain informatica architecture?

546