5.what is slowly changing dimension ?

Question Posted / narsingrao07

2 Answers
10936 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

5.what is slowly changing dimension ?..

Answer / naga bhushanam.banglore

Slowly changing dimensions(SCD) is the type of dimensions
which changes with respect to time or peeriod.

Fo s ex: there is an table which has objects like
Country City Employeeid ddress .

Here for example the say the employee of employee id say
e23321 is presently in Hyderabad after a month he is re-
located in Banglore than we can say the address dimension
is SCD w.r.t. time

We have 3 types of SCDs:
SCD-1
SCD-2
SCD-3
SCD-1:where no historical data is not maintained only
present data is maintained
SCD-2:Where complete historic + presentl data is maintained
SCD-3:Where one time historic(say previous) data+ current
data is maintained

Is This Answer Correct ?

26 Yes

0 No

5.what is slowly changing dimension ?..

Answer / mrs.narmatha

Slowly changing dimension applies to some cases where
attribute for a record varies over time.

For example a person called narmatha lived in one place
(india). So the original entry in the customer lookup table
like : customer id :100 name: narmatha country:India

At a later the person moved to UK

How should XYZ Inc. now modify its customer table to
reflect this change? This is the "Slowly Changing
Dimension" problem.

Is This Answer Correct ?

6 Yes

0 No

Post New Answer

More Business Objects Interview Questions

I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.

1 Answers Accenture,

how to hide the prompts?

7 Answers TCS,

Hi ,how many shortcut joins used in a single universe? Thanks in Advance

2 Answers

When to use local filter and when to use global filter?