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 |
WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash
could you please give me the diagram of BO 6.5 Architecture or explain about the tires?
6.what is conformed dimension? R u used?
what is report tracing in bo
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
what is variable ?
Hi friends, How many types of dimentions are they ?What are they? Thanks in advance
please anyone explain me the derived table with the problem tables.
how many reports have u created ? explain a few.
0 Answers Bank Of America, TCS,
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data
What is the difference between the public object&schema object?