Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2111


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4687


Explain when to use local filter and when to use global filter?

1311


What is the dense rank?

1141


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1009


What is the profile and package?

2257


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

942


What Is Snow Flake Schema?

1156


Explain about a task that really tested your analytical abilities?

1202


Explain about a tricky situation for which you found a very simple solution?

957


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?

981


When we use aggregate awareness function in designer?

919


What is the difference between datawarehousing and businessintelligence?

1056


what is the difference b/w the refresh and buffered data?

2284


How would you format some text using css to be verdana and bold?

1036