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

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.

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 .

Answer / ravikiran patil

The Dimension of Type 2 and Type 4 may be called as 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

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

i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?

1 Answers   JPMorgan Chase,

These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?

6 Answers   IBM, Logica CMG,

what are the special features in cognos reportnet?

0 Answers   IBM,

actually we are migrating one project to ACTUATE business intelligence solution to COGNOS REPORTNEt? why the client want to migrate from ACTUATE to COGNOS REPORTNEt? what are the special features in COGNOS REPORTNEt?

1 Answers  

How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.

3 Answers  

What is the difference between a cascading report and drill through the report?

0 Answers  

what r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??

2 Answers   Satyam,

plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?

2 Answers  

wat is called Model dimension?

0 Answers   IBM,

difference between drill through and master detail report?

2 Answers   HCL, Zensar,

How to create Events?

1 Answers  

-------------What is Coditional Prompting?

0 Answers   IBM,