Interested to Buy Any Domain ? << Click Here >> for more details...
you have two tables table 1 contains emp id,name and deptno
and tble 2 contains only depatment number some of the
depatment no of 1st table are not present in table 2 how
will you create a report only to get the departments of
which excess in table 1
- 4 Answers
- 8067 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / amutha
select empid,name,depno from table1,table2 where table1.deptno=table2.deptno(+)
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
What Is Snow Flake Schema?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Did you face any problems while creating reports? Name? Solutions?
Explain in detail about type 2(scd),
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
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?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
How many universes can be created in a project?
How to open a universe with out using the Designer ??
What is the difference between slice and dice and cross tab report?
Explain how many universes can be created in a project?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
