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

What are the diffrences between Business Objects 5.1 & 6.5 ?

1 Answers   Siemens,


In Business Objects 4.1 version what is the alternative name for broadcast agent?

1 Answers   HP,


Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik

1 Answers  


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

0 Answers  


When a report in Web intelligence is created with ten objects and save the same as PDF the report divides the report into two pages. One page with data for five objects and the other with next five objects? Is there a way to combine these ten columns in a single page view?

2 Answers  






I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?

3 Answers  


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

3 Answers   TCS,


Explain the difference between union and group?

0 Answers  


what is dashboards? what is metrics?

7 Answers   TCS,


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

0 Answers  


what r the main topics to prepare for the crystal reports? could any on help me? i want to preparing for the interviews? and also send any pdf file?

1 Answers   TCS,


what is diff between webi,deski,infoview

2 Answers  


Categories