slowly changing dimension

[Former Member]

hi,

slowly changing dimension is dimension that contain time dependent characteristic, but How can we define slowly changing dimension

Navigation, helpful to me

sunil

[Former Member]

Hi

Please see the following example

ID- Name -Dependants

100 - Tom - 5

101 - Rick -2

102 - Sunil -2

See the above contents...assume the ID represents employee ID and the dependants include parents, spouse and kids....

After sometime, dependants may increase over a period of time but noone is sure when exactly it will increase.....assume in case of a single get married and increase in dependants

So the attributes of the Employee had a slow chance of changing over the time

This kind of dimensions are called slowly changing dimensions

Regards

N Ganesh

[Former Member]

hi

thanks for reply, i want to know that how we can define slowly changing dimension in rsa1 in detail.

sunil

[Former Member]

Hi

There is nothing to find. It is a therotical concept....no functionality to find that

By finding out the attributes you can refer them slowly chaning dimension or no

Assign points if helpful

Regards

N Ganesh

[Former Member]

hi ganesh,

Thanks for reply, How can we refer attributes as slowly changing dim in infocube?

if clear, points available

sunil

[Former Member]

Hi sunil

I wil b more happier if u get cleared .....

I already told we cannot mention any dimenstion as slowly changing dimension in the system as such......The concept is theroritical only and you have to handle them finding the relationship between the attribute and the related data as given in the example

It is experience and knowledge which will help you to identify the nature of the various dimensions

Lest your points

Good BYE

N.Ganesh