There are 3 depts in dept table and one with 100 people and 2nd with 5 and 3rd with some 30 and so. i want to diplay those deptno where more than 10 people exists

Interview Candidate
Jun 18th, 2006
2
1713

Showing Answers 1 - 2 of 2 Answers

gh

Jun 20th, 2006

select count(*),deptno from dept group by deptno having count(*) >=10;

Motilal
Profile Answers by Motilal

Jun 30th, 2006

Yep! the answer provided is absolutely right. by an SQL application(Oracle).
If you want to perform it thru informatica, the Fire the same query in the SQL Override of Source qualifier transformation and make a simple pass thru mapping.
Other wise, you can also do it by using a Filter.Router transformation by giving the condition there deptno>=10.