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

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

0 Answers   Patni,

---

when we go for snow flake schema rather than star schema ?

5 Answers   TCS,

---

Explain the difference between union and group?

0 Answers  

---

how to create a derived table in designer? i need steps regarding derived table

1 Answers  

---

Can we get the data from two different databasess in reporting level?

1 Answers   Infotech,

---

please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.

1 Answers   Exilant, Wipro,

---

what is the diff between etl tool and olap tool

2 Answers  

---

i want to take a report 10 records per page. How to take it? is there any paging option in BO?

5 Answers   Cap Gemini, IBM,

---

When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?

4 Answers   Wipro,

---

What is the difference between user and versatile user?

0 Answers  

---

in xir2 how to send reports to end user

2 Answers   TCS,

---

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

0 Answers   Infosys,

---