Page 1 of 1
Bulk Loaders in DS
Posted: Mon Jan 17, 2005 6:12 am
by palaniappan
Hi,
A document that I was browsing through says that DS supports bulk loading utility for Oracle, Informix, Sybase Adaptive Server, Sybase Adaptive Server IQ, MSSQL, Redbrick, and IBM DB2 UDB.
I know that it supports Oracle, DB2 and Informix. Is the rest of the information creditable? What other bulk loaders does DS support?
Thanks, Pal.
Posted: Mon Jan 17, 2005 7:04 am
by dsrules
Include TeraData in it.
dsrules.
Posted: Mon Jan 17, 2005 7:08 am
by Luk
Hi !
Sybase ASIQ is also suported! Plug-in creates flat file wchich is later load into database.
LUK
Re: Bulk Loaders in DS
Posted: Mon Jan 17, 2005 8:01 am
by ogmios
The bulk loaders (personal experience with DB2 and Oracle) are remarkably slower than running them outside of DataStage... upto 10 times slower and more.
Ogmios.
Posted: Mon Jan 17, 2005 8:11 am
by kduke
You can easily run these outside of DataStage by writing shell scripts. DataStage can generate the control files needed for any of these. If you think they are slower then update a flat file and then run a shell script to bulk load. Let us know the results. I would like to know which is slower and by how much.
Posted: Mon Jan 17, 2005 3:12 pm
by ray.wurlod
The only Red Brick stage in DataStage is the bulk loader stage.
Says something important about purpose-designed DW databases, I feel.
Posted: Mon Jan 17, 2005 6:52 pm
by vmcburney
Often it is not the bulk loader that is slower but the creation of the data files. You can save time by creating the data file with a sequential file stage and then calling the bulk loader externally.
I have all the Standard Edition RDBMS plugins loaded, I can see DB2/UDB Load, Informix Load and Informix XPS Load, Oracle 7 Load and Oracle OCI Load, Redbrick Load, Sybase BCP Load and Sybase IQ 12 Load, Teradata Load and Teradata Multi Load. It's a Unix installation so I don't see an MSSQL Load.