what is meant by slowly changing dimensions?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What task is 98% of the required work of a business analyst?

576


Differences between business objects and web intelligence reports?

651


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2400


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1881


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

1829






How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

1969


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

587


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?

9876


How to create Index to the table in the universe designer and how it improves the Query performence

2115


What sort of existing documents should business analysts refer to when starting on a new project?

616


Explain when we use aggregate awareness function in designer?

584


Explain is there any default username & pwd for bo designer & supervisor?

593


What is package in BO

2681


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1574


Is there any other repository domains rather than universe, security, document?

593