5.what is slowly changing dimension ?
Answers were Sorted based on User's Feedback
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 |
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 |
Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?
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
What is #DATASYNC error how to remove it?
can anybody explain me in detail about software development life cycle of business objects in detail?
What are the difference between merge,auto merge and extended merge ?
Is there any other repository domains rather than universe, security, document?
What is the use of BO SDK?
How to generate the report from excel sheet?
What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?
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?
How to create an popup in the WEBI report if the report is showing partial result?