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 |
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
I have all the below SAP – Business Objects Certification latest Dumps, I scored 100 % Score with these Dumps
Can master data change???if yes then how it'll change.....please explain with example...... thanx
Difference between Decode and Case?
what is data cubes??
can we cretae views in universe level?
How many universes will run maximum in single project
CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?
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?
what is meant by report busting
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?