explain merge dimensions with real time in DWH?
Answer Posted / v.sivakumar
Merge dimension:
Merging of two common dimension from different table to
retrieve some values is known as merging dimension.
For Example:
Table 1: contains column Empid and Emp name
Table 2:Contains column Empid and salary
you have Requirement that the client need the emp name and
salary .
In this case we have to create two data provider one for
retrieving the data from table 1 and other for table 2.
and by merging Empid in the two data providers you can get
the value for emp name and salary
| Is This Answer Correct ? | 30 Yes | 6 No |
Post New Answer View All Answers
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Can anybody tell me what are the tuning problems?
Explain is there any other repository domains rather than universe, security, document?
Is there any other repository domains rather than universe, security, document?
how many reports have u created ? explain a few.
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 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)?
Explain when we use aggregate awareness function in designer?
explain in detail about type 3?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
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 Is The Difference Between Oltp And Olap?
Difference between zabo and webi?
Explain is data mart?