Extract and Load from database not using DataStage Server

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Nic
Charter Member
Charter Member
Posts: 24
Joined: Mon Sep 26, 2005 1:08 pm
Location: UK

Extract and Load from database not using DataStage Server

Post by Nic »

If you are extracting from a database (any for example Oracle) and loading to another database (again any for example DB2) and not performing any manipulation does the data still go through the DataStage server or can you bypass the DS Server and get the data to be loaded directly from one db to another. I know on the design side DataStage inserts an "invisible transformer", at least it used to on the server edition but don't know what happens now with PX. I am asking as an investigation into network impact. Please let me know if my question is not clear.
Thanks for all your help in advance.
Post Reply