explain merge dimensions with real time in DWH?
- 1 Answers
- 8303 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
Explain what is the difference between slice and dice and cross tab report?
Explain what is the difference between business requirement document and use case document.
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is difference between webi and infoview?
What is the difference between slice and dice and cross tab report?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is the profile and package?
U r project in which stage in implementation?
Can anybody tell me what are the tuning problems?
What we need to discuss with designer before starting the universe designing.
Explain the difference between detect alias and detect context?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is report template in b.o?
Explain about a time when you discovered a more efficient way to do a work task?
When to use local filter and when to use global filter?
