Hi All,
I have a sql in a test file in a remote location. (on the datastage server).
Can someone please suggest me if there is any way I can call this sql in ETL job and run it using oracle enterprise edition (we have Oracle as source and target) and write the output.
we want to keep the sql in remote location because if any changes to that sql we need not have to change the ETL job.
Thanks
pavan
Call sql from remote location into ETL
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
-
- Premium Member
- Posts: 263
- Joined: Fri Sep 23, 2005 6:49 am
Call sql from remote location into ETL
Actually the file will be local to the datastage server. where can I find the sql file option in the Oracle Enterprise edition stage.
Thanks
Pavan
Thanks
Pavan