Answer / vidya

Short cut Join providing an alternative path between two
tables,bypassing intermediate tables, leading to the same
result,regardless of direction. Optimizes query time by
cutting long join paths as short as possible.

Theta join Link tables based on a relationship other than
equality between two columns.

Answer / vams_gk

shortcut join :it is direct join between source and
destination
example :country-->region--.city

we can coneect country and city using shortcut join

theta join :non equality condition between two tables

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?

0 Answers  

---

How would I achieve Traffic Lighting in Business Objects

3 Answers   Virtusa,

---

Can anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash

3 Answers  

---

Explain in detail about type 2(scd),

0 Answers  

---

CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?

0 Answers  

---

IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?

3 Answers   Accenture,

---

Explain how many universes can be created in a project?

0 Answers  

---

when you have three fact table and there is no relationship between them. How you will tackle the issue.

2 Answers   BMC, TCS,

---

Have you worked with multiple data sources? If yes. How do you link them?

1 Answers  

---

HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..

4 Answers   IBM,

---

HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?

4 Answers   CitiGroup,

---

can anybody tell me about complicated object you have created

0 Answers  

---