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
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is the difference between slice and dice and cross tab report?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain 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)?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain what is the difference between business requirement document and use case document.
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain is data mart?
Did you face any problems while creating reports? Name? Solutions?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
can anybody tell me about complicated object you have created
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 we need to discuss with designer before starting the universe designing.
