Interested to Buy Any Domain ? << Click Here >> for more details...
what is slowly growing dimension??
- 6 Answers
- 17332 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
how u publish the packages in framework manager
What is meant by report studio short cut?
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....
what is a query subjects item?
what is catalog and types of catalogs in cagnos and which is better?
Can you define cube?
can we insert all types of charts in a list report? what r the realtime prompts?
What are the differences between cognos 8.2 and cognos 8.4? Please help me..
how to test reports in cognos?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
Sales person are there in one company How to do Bursting on this particular requirement?
What is Cognos Mashup Services .what is the use of Cognos Mashup Services and where to use.
Teradata 
