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

what is the difference between Ranking and sort-out in bo?

2 Answers   iNautix, TCS,


What are the join problems comes appart from loop,chasm & fan Traps

0 Answers   IBM,


what is xcelsius architecture?

0 Answers   Zensar,


what is profile and packages in BOXI??

1 Answers  


how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?

1 Answers   Accenture, TCS,


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

0 Answers  


Can Bo generates the Report from the cubical data Explain?

0 Answers   Wipro,


I have 4 tables having many to many relationships between the tables? How i can get correct results in the report?

2 Answers  


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

0 Answers   TCS,


how can i add two different reports in the same document?

5 Answers   TCS,


What is BOMain.Key?

5 Answers   Cognizant,


in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?

1 Answers   iFlex,


Categories