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

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

0 Answers  


I have all the below SAP – Business Objects Certification latest Dumps, I scored 100 % Score with these Dumps

17 Answers   IBM,


Can master data change???if yes then how it'll change.....please explain with example...... thanx

1 Answers  


Difference between Decode and Case?

1 Answers   NIIT, TCS,


what is data cubes??

2 Answers  






can we cretae views in universe level?

2 Answers  


How many universes will run maximum in single project

1 Answers   HP,


CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?

0 Answers  


how do you give security to universe ?

2 Answers   InfoStep, Tech Mahindra,


Any body help me...what are challenges did u face in Business object project?

1 Answers  


what is meant by report busting

2 Answers   TCS,


Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?

2 Answers   iFlex,


Categories