Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can Bo generates the Report from the cubical data Explain?
What we need to discuss with designer before starting the universe designing.
Explain how many universes can be created in a project?
8. How much supervision have you typically received in your previous job?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Can we create universe with no cache??
what will be the contents for a functional requirements specifications
Explain what three things do you consider to be the most important factors for a manager?
Explain about alerts in bos, under what situation we need to use alerts?
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
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
How to generate the report from excel sheet?
Explain the difference between union and group?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
