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 |
bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?
What is metrics?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
how do u implement dense rank in bo reports?
Can any one say me wat does"maintanence of universe" means wit?
2 Answers Business Intelligence Analytics, NAL, TCS,
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
6.what is conformed dimension? R u used?
What is thin client And thick client..?
How many universe dfi you create if you have 2 years of experience in BO
I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?
how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????
What is meant by data federator and what is the use of it?