explain merge dimensions with real time in DWH?
- 1 Answers
- 8561 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is aggregate table and aggregate fact table ... Any examples of both?
Explain the difference between union and group?
What we need to discuss with designer before starting the universe designing.
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain what would you consider as your biggest achievement and why?
Explain what are the steps to be taken to schedule the report?
Explain about alerts in bos, under what situation we need to use alerts?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What Is Snow Flake Schema?
What is the dense rank?
What is the difference in creating filters in designer and business objects?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
