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

bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?

7 Answers   PCS, TCS,


What is metrics?

2 Answers  


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

0 Answers  


how do u implement dense rank in bo reports?

2 Answers   CTS,


Can any one say me wat does"maintanence of universe" means wit?

2 Answers   Business Intelligence Analytics, NAL, TCS,


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

0 Answers  


6.what is conformed dimension? R u used?

8 Answers   TCS,


What is thin client And thick client..?

2 Answers  


How many universe dfi you create if you have 2 years of experience in BO

6 Answers   IBM,


I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?

2 Answers   Patni,


how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????

1 Answers   IBM,


What is meant by data federator and what is the use of it?

2 Answers   TCS,


Categories