Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is slowly growing dimension??

Answers were Sorted based on User's Feedback



what is slowly growing dimension??..

Answer / 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

what is slowly growing dimension??..

Answer / 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

what is slowly growing dimension??..

Answer / aakanksha

Well its actually the concept of SCD (Slowly changing
deimension)which are of three types type1,type2,type3
Type1:-keeps the information about the current record and
no history is maintained it it.

Type2:-Keeps the proper historical information by including
a surrogate key or we can say a flag which will indicate or
point to the currwent information.

Type3:-Keeps the partial historical information we main
tain it by keeping or including two columns say start date
and end date but it si not that much helpful as compare to
the type 2 slowly changing dimension as type 2 provides
more information than type3 .

Is This Answer Correct ?    4 Yes 4 No

what is slowly growing dimension??..

Answer / ravikiran patil

The Dimension of Type 2 and Type 4 may be called as slowly growing dimension

Is This Answer Correct ?    0 Yes 0 No

what is slowly growing dimension??..

Answer / guest

slowly growing dimension means Slowly changed dimensions
that means the name it self defines the data which will
change periodicaly.There are 3 diff types of SCD's they are
1.scd-TYPE-1
2.scd-TYPE-2
3.scd-TYPE-3

Is This Answer Correct ?    1 Yes 2 No

what is slowly growing dimension??..

Answer / numbsyd

it's been days since the question was asked and no one
bothered answering,never mind. since i gained some knowledge
about the term 'growing' dimension after the question was
aked in the interview, i'm giving the answer.
among three SCD's, one updates the existing dimension
leaving no traces of history and lets ignore this, the
second stores historical data with a surrogate key and
maintains complete history, the third records partial history.

among all these, apparantly the second dimension is the only
growing dimension in contrast to the third SCD. they
sometimes call it Second dimension as well, you know why??
just because they could

Is This Answer Correct ?    2 Yes 8 No

Post New Answer



More Cognos Interview Questions

what are the components having in the report studio using interface eg:insertable objects pan,properties pan

1 Answers   HCL,


What is slicer & dicer ? what is sub session parameter ?

2 Answers   Cap Gemini,


what is a bookmark? what concept we use in bookmarking? please tell me how to create bookmarks(with explore)?

2 Answers   IBM,


HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

0 Answers  


What are the different types of important services used in cognos?

0 Answers  






what are the tabs in cognos ?

2 Answers  


what is hints in cognos and where we use it.

0 Answers   Satyam,


What is a dashboard in Cognos Report Studio and how do we creae it

2 Answers  


What are all the advantages of Cognos?

0 Answers  


Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?

5 Answers   TCS,


What is Star schema group?

1 Answers   IBM,


How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.

5 Answers   HSBC,






Categories