explain merge dimensions with real time in DWH?
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
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain when to use local filter and when to use global filter?
What is the dense rank?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What is the profile and package?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What Is Snow Flake Schema?
Explain about a task that really tested your analytical abilities?
Explain about a tricky situation for which you found a very simple solution?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
When we use aggregate awareness function in designer?
What is the difference between datawarehousing and businessintelligence?
what is the difference b/w the refresh and buffered data?
How would you format some text using css to be verdana and bold?