Answer Posted / manveer

More no of records in trap because:
For example:

A >- B -< C

( Employees >-- Showroom --< Salary)

- Each showroom has many employees
- Each showroom has many annual salary figures
The number of employee records should not impact the total salary on the report.

If a query is written that spanned all three of those tables the data from table A and C, there would be duplicated and the measure values would be exaggerated. For example,
- X rows on the left
- Y rows on the right
- X * Y rows in the combined set


Less no of records in loop as there is an extra join in a loop, that means one more restriction to the data. That extra join filter out the data and restrict the no of rows retrieved

Explain in detail about type 2(scd),

1047

---

How to open a universe with out using the Designer ??

7455

---

Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

3016

---

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2363

---

Explain about a time when you discovered a more efficient way to do a work task?

1088

---

what are the tables used in health care domain project and columns used in report?

4463

---

Explain what are the measure objects?

935

---

When we use aggregate awareness function in designer?

909

---

What Is The Difference Between Oltp And Olap?

1064

---

What is aggregate table and aggregate fact table ... Any examples of both?

1003

---

Explain what is the difference between business requirement document and use case document.

963

---

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?

970

---

Explain how we drill up week to month?

1041

---

in sap bi we have wad, then why we go for sap bo

3326

---

what is document design in boxi,have u participate in that

2085

---