Answer Posted / 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 |
Post New Answer View All Answers
What is top business?
How would you format some text using css to be verdana and bold?
what is universe null
8. How much supervision have you typically received in your previous job?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Explain what would you consider as your biggest achievement and why?
Explain about a time when you discovered a more efficient way to do a work task?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is difference between webi and infoview?
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?
Explain when to use local filter and when to use global filter?
Explain is data mart?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain is there any other repository domains rather than universe, security, document?