please anyone explain the equi join,outer joi(right outer
join and left outer join),theta join and self join with
database tables.
Answer Posted / punnaiahbabu
Equi join means equlity condition b/w tables
left outerjoin :matching and unmatching from left side onley
matched from right side.........
right outer join:matching and unmatching from right side
onley matched from left side.
outer join :matching and unmatching displed both of the tables
self join:we will right on sql query on the table.
Is This Answer Correct ? | 7 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?
Explain which versions are used in the bo dashboard work?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
how to prepare the documentation in business objects and where to get the requirement?
what are the day to day activities of BO administrator ?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
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,
what is the difference b/w the refresh and buffered data?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
How to generate the report from excel sheet?
Can more than 1 metric be applied on an analytic in business objects?
How were the reports scheduled and how to resolve unexecuted documents?
how to create metric universe ?