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 many ways you can restrict data in business objects?

5 Answers   TCS,


what is optional prompt in boxi r2

4 Answers   Mind Tree,


How to create universe in business objects enterprise 11.5

1 Answers  


Tell me the difference between cmc and cms?

4 Answers   Wipro,


What is a Set?

1 Answers  


IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

1 Answers   Accenture,


difference between xir2 and 6.5 version

4 Answers  


HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?

2 Answers  


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

0 Answers  


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)?

0 Answers  


Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.

1 Answers  


What is the local filter and global filter in bo's?

8 Answers  


Categories