DSXchange

If all you are doing is moving the data from one table to another, and if everthing is an insert into the destination table, then the best way is to have an OCI stage to read the data, a transform stage and an output to a Oracle bulk-load stage. The bulk load stage will write the data to a sequentia...

In the process of loading a big table into an other on a different server , what we built is a parallel, direct, oci to oci job ( not transformer) , as follow: OCI1 ------> OCI3 OCI2 ------> OCI4 OCI 1 has a select where xxx> VALUE OCI 2 has a select where xxx >> SHailey@CSCUS.JNJ.com 18/07/2002 17:...

Karthik, I had a similar problem to yours about loading into an oracle stage and the job taking a long time. What I did and recommend is to just write out to a sequential file. Then in a second job use that sequential file as the input and load the records into the oracle table. In this second job y...

Hi everyone, Im working with MetaStage 2.3 and I would like to submit you a question. Im customizing the template to generate html documentation, and Im translating the description of the produced documentation in my country language. For the string in the ObjectTemplate, sure Ive no problem (for ex...

One can do a lot of things with DataStage as it is. Some more complex tasks can be achieved by additional coding in Universe Basic. However, some people are reluctant to learn Universe Basic beyond the basics of being able to code job control or routines. If a task can be performed in Perl or via a ...

Are you cleaning data WHILE it they are being processed through DataStage, or before or after? If its before or after, use a before-job, before-stage, after-stage or after-job routine to invoke perl directly (using a standard command line passed to the ExecSH routine (for UNIX) or the ExecDOS routin...

i need to use perl script to clean data. for that purpose if i have a perl script then what are the steps for using script in Datastage?? > ---------- > From: Raymond Wurlod[SMTP:wurlodr@au1.ibm.com] > Reply To: datastage-users@oliver.com > Sent: Thursday, July 18, 2002 11:37 AM > To: datastage-user...

This was answered only a week ago on this very list. Get the ClickPack for DataStage, and detailed instructions for using Perl accompany it. I wonder, though, why (and where in DataStage) you are seeking to use Perl? Are you trying to get DataStage to do something it does very well in its own langua...

Hi I need to know how to use perl script in Datastage..Please send me in detail. Thanx. ************************************************************************** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDEN...

DataStage default sequential file processing is to convert "" to NULL. This can be modified in a Sequential File stage by editing its link properties and specifying a different representation of NULL. The RDBLOAD stage type also writes a sequential file, but there is no mechanism provided for specif...

I have a source Red Brick table of which a column contains empty strings . This column amongst others is extracted using an ODBC stage and sent to a transform. The transform

If I remember correctly, i think DS 5.2 MF edition has the capability of creating parameters like table definitions and load them like table definitions. I believe future release of DataStage (server) will have this feature as well. Pavan -----Original Message----- From: Raymond Wurlod To: datastage...

Hi, Our job created one hash file and a sequential file, from the same table in two different links to the OCI. At the end of creation of the hash file, this it will not be use any more in our job, but the job still processing other transformation. We can use this hash file in other job, as a lookup...

This is a topic for an orphaned message.

The API to which stage types are written allows for provision of "import metadata" and "view data" capability. The author of the stage type has to provide the functionality. Clearly the author of the OLEDB stage elected not to provide the "view data" functionality. OK, this does not address the ques...