what is meant by slowly changing dimensions?

Answers were Sorted based on User's Feedback



what is meant by slowly changing dimensions? ..

Answer / nareshkumar

Dimensions that change over time are called Slowly Changing
Dimensions. There are three types namely,
1) Overwriting the old values
2) Creating an another additional record
3) Creating new fields

Is This Answer Correct ?    7 Yes 0 No

what is meant by slowly changing dimensions? ..

Answer / surya

Master data occur in the OLTP system and that can't change
regularly,When the changes are occured in the OLTP
system,that changes can be handle by the dimension
tables.Such type of dimensions is called Slowly changing
dimensions.

There are three types of dimensions
TYPE1(Maintain only current data)
TYPE2(Maintain complete historic data)
TYPE3(Maintain one historic data)

Is This Answer Correct ?    4 Yes 0 No

what is meant by slowly changing dimensions? ..

Answer / mahesh225

The data present in the dimension table changess from time to time.

For example .

Customer is staying in Inda now and he may moves to Us in next year.Similerly from Us to Uk and so on.

So to maintain this kind of dimentional historical information we have SCD type1,Type2 and Type3.

www.futuresoftworld.com

Thanks

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Business Objects Interview Questions

Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.

1 Answers  


What is object stores?

0 Answers  


How to hide the table s in webi?can any one tell me plzzzzzzzz

9 Answers   Accenture, TCS,


How can you check the universe?

3 Answers  


What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?

2 Answers  






Explain the data types present in bo and what happens if we implement view in the designer and report?

0 Answers  


Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important

7 Answers   Zylog,


What is a Set?

1 Answers  


What is security level in BO ?

3 Answers   Accenture,


How many tables can an universe contain is their any limit to insert tables in the universe?

3 Answers  


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

2 Answers   HCL, IBM,


How to create a report template BO XI R2

2 Answers   Infosys, LBM,


Categories