Hi All,
Since I'm new to Datastage unable to prepare design for the below one. Please help me:
For Query1 and Query2 I'm not sure how to design the parallel job.
Query1:
SELECT * FROM ABC WHERE XXX IN (SELECT XXX FROM ABC
where STAT = 'CLOSE' AND FLAG = 0 AND TRUNC((sysDate-CURRENTDATE) / 365) >= 2
MINUS
SELECT XXX FROM DEF WHERE LEVEL <> 0 )
Query2:
select * from ABC WHERE XXX IN (SELECT XXX FROM ABC
where STAT='CLOSE' AND FLAG = 0 AND TRUNC((sysDate-CURRENTDATE) / 365) >= 2
MINUS
SELECT XXX FROM FGH WHERE TYPE in ('ggg','hhh')
)
Thanks in Advance
Need Help in parallel Job design for below logic
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 31
- Joined: Mon Jun 28, 2010 5:15 am
- Location: pune