Interested to Buy Any Domain ? << Click Here >> for more details...
When we r going for Short_cut join & It's Resolution???
Plz provide one scenario??
- 2 Answers
- 7534 Views
- Rolta, TCS, I also Faced
- E-Mail Answers
Answer Posted / kishore babu
if we have 3 tables A,B,C. our requirement is A->B->C &A->C
That means we make three joins. the referential integrity says
joins must be no.of tables-1.so the join A->c join make as a
short cut join.more than 3 tables we dont go for short cut
join.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What is report template in b.o?
Explain how many universes can be created in a project?
what is document design in boxi,have u participate in that
what is universe null
Explain about a task that really tested your analytical abilities?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What would you consider as your biggest achievement and why?
How many universes can be created in a project?
is it possible to export the webi reports to crystal reports?with out using businessview?
What is the difference between the public object&schema object?
What is top business?
How to execute the plsql procedure from the report by clicking with mouse?
Explain about alerts in bos, under what situation we need to use alerts?
