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

Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?

2 Answers   iFlex,

---

Which command using Query Analyzer will give you the version of SQL server and operating system ?

1 Answers  

---

What is the difference between derived table and views? which one gives better performance?

2 Answers   TCS,

---

'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.

1 Answers  

---

how to restrict null values in webi report?

2 Answers   InfoStep,

---

What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function

6 Answers   Cap Gemini, Deloitte,

---

What is mean by tuning the report?

1 Answers  

---

what is the diff between etl tool and olap tool

2 Answers  

---

Explain in Detail about Measure Objects? and what is the use of it? How to create it?

5 Answers  

---

What is diff between InfoView and Zero BOAdmin (ZABO)?

2 Answers   Nucleus Software,

---

IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me

2 Answers   Accenture,

---

What is the drill up , drill down, drill by , drill trough ?

3 Answers   TCS,

---