One of the main use of Alias is to solve loop..So consider you have a loop

Steps to create alias and apply

Question Posted / sj

2 Answers
5528 Views
I also Faced
E-Mail Answers

Answer Posted / sj

One of the main use of Alias is to solve loop..So consider
you have a loop like A-->B-->C-->D-->A
in this case the loop ends on A.

So create a alias tale of Table A like A_alias and breathe
loop like below
A-->B-->C-->D-->A_alias,in this way loop is removed

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between absolute and relative div positioning?

1047

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

5063

Explain in detail about type 1?

1652

Explain is data mart?

1020

what will be the contents for a functional requirements specifications

2354

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2229

Explain what would you consider as your biggest achievement and why?

984

how to create metric universe ?

2342

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

2273

Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

1026

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1182

Can Bo generates the Report from the cubical data Explain?

2036

Explain what three things do you consider to be the most important factors for a manager?

1009

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2445

How to generate the report from excel sheet?

1179