What is self join

Answer Posted / nitish

A table is joining to itself is called as a self join let us take an example of there is a table emp and dept, the user want to analyse the report how many employees are working in a particular dept

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

550


Differences between business objects and web intelligence reports?

651


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

599


What Is Snow Flake Schema?

666


What task is 98% of the required work of a business analyst?

575






What is the difference between slice and dice and cross tab report?

599


Explain which versions are used in the bo dashboard work?

633


What is object stores?

583


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)?

571


how to prepare the documentation in business objects and where to get the requirement?

1778


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1619


Explain 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)?

539


What is the profile and package?

1764


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?

543


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1581