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
- 8061 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rajesh kumar
select empid,name,depno from table1,table2 where
table1.deptno not in table2.deptno
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is the dense rank?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain about a tricky situation for which you found a very simple solution?
What task is 98% of the required work of a business analyst?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
How to schedule the report in b.o?
Explain in detail about type 1?
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...
Explain difference between zabo and webi?
Give some information on report bursting?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
