Hi All,
Need help to prepare job design for the below SQL query operation.
I cant use this query directly in Oracle Stage as the tables ABC and DEF are from different databases.
Please help me in how to develop the job for the same.
SELECT * FROM ABC WHERE (xxx,yyy,zzz) IN
(
SELECT xxx,yyy,zzz FROM ABC WHERE
STAT='DONE' AND FLAG=0 AND TRUNC((sysDate-STRTDATE) / 365) >= 2
MINUS
SELECT xxx,yyy,zzz FROM DEF WHERE LEVEL <> 1
)
Thanks in Advance,
Hema
Need help for job implementation
Moderators: chulett, rschirm, roy
Oracle source stage (SELECT xxx,yyy,zzz FROM ABC WHERE
STAT='DONE' AND FLAG=0 AND TRUNC((sysDate-STRTDATE) / 365) >= 2)
Lookup with reject link (on keys xxx,yyy,zzz)
Oracle reference stage (SELECT xxx,yyy,zzz FROM DEF WHERE LEVEL <> 1)
The MINUS result dataset would then be the output on the reject link
STAT='DONE' AND FLAG=0 AND TRUNC((sysDate-STRTDATE) / 365) >= 2)
Lookup with reject link (on keys xxx,yyy,zzz)
Oracle reference stage (SELECT xxx,yyy,zzz FROM DEF WHERE LEVEL <> 1)
The MINUS result dataset would then be the output on the reject link
_________________
- Susanne
- Susanne