explain merge dimensions with real time in DWH?
Answer / 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 |
Difference between Decode and Case?
What are all difference between business objects 6.5 and xi r2?
Is it possible to generate reports without having knowledge of the Universe structure?
What is Designer?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Pls Explain about the different between 6.5 & Xi R2
How to open a universe with out using the Designer ??
it is possible to link two universes of separate functional domain ?
I have a report with n number of records. i want to take alternative rows as a red in color. How to make it?
WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?
difference between web intelligence,crystal reports and desktop intelligents
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?