Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 View All Answers
How many universes can be created in a project?
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 is the difference between the public object&schema object?
Explain the difference between detect alias and detect context?
what is the difference b/w the refresh and buffered data?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What we need to discuss with designer before starting the universe designing.
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain in detail about type 2(scd),
When we use aggregate awareness function in designer?
What is the dense rank?
How to restrict password to a user while sending a document in .pdf format
What Is The Difference Between Oltp And Olap?
Explain when to use local filter and when to use global filter?
