Job design

Noozeethullah · Post by **Noozeethullah** » Thu Apr 05, 2012 1:24 am

Hi guys I am stuck up with the job design for the below sql queries. Please help:

select empno from emp_1 minus select empno from emp_2;

I need the emp_1 rejected empno into the target file

kandyshandy · Post by **kandyshandy** » Thu Apr 05, 2012 2:41 am

User defined SQL in respective DB stage!!

pandeesh · Post by **pandeesh** » Thu Apr 05, 2012 2:57 am

What about using difference stage ,if you want to do in datastage?

udayk_2007 · Post by **udayk_2007** » Mon Apr 09, 2012 6:02 am

How abt using a lookup. The reject file of the look-up will give you the required data.

Regards
Ulhas

priyadarshikunal · Post by **priyadarshikunal** » Mon Apr 09, 2012 7:27 am

There are many ways to do it but I should ask what the OP has tried?

mobashshar · Post by **mobashshar** » Mon Apr 09, 2012 11:21 am

Hi Sahana,
You should get the empno not present in emp_2 table by using this query. Nothing wrong in sql.
What is your requirement?

jerome_rajan · Post by **jerome_rajan** » Mon Apr 09, 2012 1:16 pm

Just so I understand, you need all empno from emp_1 that are not present in emp_2, right?

Off the top of my head, I can think of a design with a lookup.

The primary link will have emp_1 data and the reference link will have emp_2. perform a lookup on empno.
The data rejected by the lookup would be the data not present in emp_2. You can capture this in a reject file and use it downstream.

Hope this helps.