explain merge dimensions with real time in DWH?



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

Post New Answer

More Business Objects Interview Questions

How to create a Pop-up in BOXIR2. Ex:- A class is having an object as "AGE", whenever this object is used in the reporting level automatically a pop- up will be coming which shows a prompt as "Please use the object DOB".

3 Answers  


How to Avoid the overlaping the blocks in WEBI.

3 Answers  


What is meant by ZABO and FC(full-client)?

2 Answers  


11.what are the features in BO?

2 Answers   IBM, TCS,


why we are using derived tables ?how it will help?

2 Answers  






difference between web intelligence,crystal reports and desktop intelligents

4 Answers  


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers  


how to connect one to one report? Explain with example?

5 Answers   TCS,


Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example

1 Answers   IBM,


how to connect the hyperlink in webi reports?

7 Answers   TCS,


what is the difference between bo and cognos?

1 Answers  


WHAT IS SAP BO AND BO?

1 Answers  


Categories