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

Can anybody explain me ? without creating the alias can we resolve the fantrap?

4 Answers  


Can anybody tell me the difference b/w canned and adhoc reporting?.

5 Answers  


I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.

3 Answers  


hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks

0 Answers  


What is the drill up , drill down, drill by , drill trough ?

3 Answers   TCS,






Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

0 Answers  


what is isolated joins in check integrity

2 Answers   Accenture, Polaris,


any difficulitis have you phase while creating bo reports and how did u solve it

0 Answers  


I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance

5 Answers   TCS,


how to hide the prompts?

7 Answers   TCS,


what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance

2 Answers   IBM,


i want to take a report 10 records per page. How to take it? is there any paging option in BO?

5 Answers   Cap Gemini, IBM,


Categories