satyaneerumalla

 Profile Answers by satyaneerumalla Questions by satyaneerumalla

• Sep 4th, 2006

 

hi

a rapidly changing dimensions are those in which values are changing continuously and giving lot of difficulty to maintain them.

i am giving one of the best real world example which i found in some website while browsing. go through it. i am sure you like it.

description of a rapidly changing dimension by that person:

I'm trying to model a retailing case . I'm having a SKU dimension
of around 150,000 unique products which is already a SCD Type 2 for
some attributes. In addition I'm willing to track changes of the sales
and purchase price. However these prices change almost daily for quite
a lot of these products leading to a huge dimensional table and requiring  continuous updations. 

so a better option would be shift those attributes into a fact table as facts, which solves the problem.

vvkiran

• Sep 14th, 2006

 

hi If you dont mine plz tell me how to creat rapidly changing dimensinons. and one more question.... please tell me what is the use of custom transformation.. thanking u.bye.

Sravan

• Sep 14th, 2006

 

Rapidly changing dimension is that whre the dimensions changes quikly.

best example is ATM transactions(BANKS).The data being changes continuesly and concurently for each second so it is very difficult to capture this dimensions. 

calltomadhu

 Profile Answers by calltomadhu 

• Sep 22nd, 2006

 

hi

question itself there that data is quite freequently changing. Changing means it can be modify or added.

Example.

The best example of this one is Sales Table.