Is it possible to use Oracle bulk load stage if ETL svr and DB svr are in different box ?
If it is possible, does it require any set-up ?
Any advice pls.
Thanks
Oracle Bulk Load stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can use the stage to produce the ctl and dat files, but you would then need to move these to the Oracle server (perhaps using an FTP script) and trigger the sqlldr command on that machine (perhaps using rsh).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia
Yeah I agree with Craig.
Recently we have tested bulkloader where DB and DS are on different machine. We tested Automatic mode. It worked fine.
Manual Mode:
We are trying execute a afterroutine in manual orabulk stage job to load data.
But we are unable to trigger sqldr command from DSExecute to perform manual load. Anyone has idea what might be wrong ?
Please help.
Recently we have tested bulkloader where DB and DS are on different machine. We tested Automatic mode. It worked fine.
Manual Mode:
We are trying execute a afterroutine in manual orabulk stage job to load data.
But we are unable to trigger sqldr command from DSExecute to perform manual load. Anyone has idea what might be wrong ?
Please help.
-Raj
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: