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
- 8227 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
Explain how many universes can be created in a project?
Explain about a task that really tested your analytical abilities?
Explain what task is 98% of the required work of a business analyst?
what are the tables used in health care domain project and columns used in report?
Explain is there any other repository domains rather than universe, security, document?
What is package in BO
What are all difference between business objects 6.5 and xi r2?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain what three things do you consider to be the most important factors for a manager?
How were the reports scheduled and how to resolve unexecuted documents?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
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...
What is top business?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
