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
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to execute the plsql procedure from the report by clicking with mouse?
what are the tables used in health care domain project and columns used in report?
Explain what are the steps to do to use alerts in bo?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
Explain what task is 98% of the required work of a business analyst?
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.
What is package in BO
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What would you consider as your biggest achievement and why?
is it possible to export the webi reports to crystal reports?with out using businessview?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
How were the reports scheduled and how to resolve unexecuted documents?
what will be the contents for a functional requirements specifications