Interested to Buy Any Domain ? << Click Here >> for more details...
explain merge dimensions with real time in DWH?
- 1 Answers
- 9087 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
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What are the join problems comes appart from loop,chasm & fan Traps
What is the difference between slice and dice and cross tab report?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is the difference between datawarehousing and businessintelligence?
What are all difference between business objects 6.5 and xi r2?
What Is The Difference Between Oltp And Olap?
Explain in detail about type 1?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
U r project in which stage in implementation?
Explain about a time when you discovered a more efficient way to do a work task?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Difference between zabo and webi?
how to create metric universe ?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
