DSXchange

Maybe.. I just need to optimize the entire process, so either an improvement on Selection or transfer will help. Any advise??

Hi, I have a source table which resides in a remote DB. I get the records from this table based on the last_update_date column. Unfortunately, this table is not range-partitioned in the last_update_date column. My query is simple, no joins and so gets only from one table. As simple as: SELECT col1, ...

Hi, Is there such thing as bulk select and insert in DataStage? I have something like: SELECT from remote DB --> transformer --> INSERT to DW I noticed that the records are one by one going through the transformer, then to INSERT stage. I find this very slow. Is it possible to bulk colelct them befo...

Are you talking about Postgres "dblink"? quote] Nope, i mean Oracle dblink. In my experience, a dblink is neither faster nor a silver bullet. Hi Craig, thanks for welcoming me :) I am just quite not aware of how DS works. Wihout a dblink, does it get the data from db1 to its local memory ...

Hi,
I have a source table which is in database SourceDB and the target table is in TargetDB. The load runs very slow. Will a dblink help?? Right now, I do not use and dblink since in DataStage, we simply specify the database (DSN), right?

thanks in advance..