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
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!!!
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain how we drill up week to month?
When to use local filter and when to use global filter?
Is there any other repository domains rather than universe, security, document?
Differences between business objects and web intelligence reports?
How were the reports scheduled and how to resolve unexecuted documents?
What is the difference between slice and dice and cross tab report?
What is a bo repository?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is the dense rank?
what are the tables used in health care domain project and columns used in report?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
