Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


5.what is slowly changing dimension ?

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

Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?

2 Answers  


What are the advantages of setting up LOVs in the Universe?

2 Answers   Cap Gemini, Deloitte,


when to go for alias and when to go for contexts

4 Answers  


What is #DATASYNC error how to remove it?

2 Answers   IBM, TCS,


can anybody explain me in detail about software development life cycle of business objects in detail?

1 Answers  


What are the difference between merge,auto merge and extended merge ?

1 Answers   Cap Gemini,


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

0 Answers  


What is the use of BO SDK?

5 Answers  


How to generate the report from excel sheet?

0 Answers  


What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?

3 Answers  


I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?

3 Answers   Wipro,


How to create an popup in the WEBI report if the report is showing partial result?

2 Answers   Banking, IBM,


Categories