DSXchange

Hello All, I have a oracle table with 15.5 million records. When I am trying to create a hash file, the job gets struck at 10 million. Job does not abort but the number of records does not increase at all. I stopped the job and re-started but it gets struck at different a count. Is there any way I c...

I am getting unpredictable behavior from datastage. I wrote my job, few month ago. Everything was working fine until recently, one of the job started aborting. In the event log, I do not get error message except job aborted. I copied the job as different name and it works fine. But whenever I run th...

Thanks. I am in 4.1 though. Thanks anyway! "Riccardo Tani" cc: Subject: Re: Parallel Dml kin datastage 07/16/2002 03:51 AM Please respond to datastage-users Hi, If you are working with DS4.2 and later, there should be After and Before tabs into OCI stage where you can perform a statement like ALTER....

Tony, Both are insert of update jobs. They are seperate jobs, either one can be called first. It seems there isnt a quick and easy way to say dont write this column if value is null! V "Tony Curcio" To: datastage-users 16-Jul-2002 cc: 14:51 Subject: Re: A quick and easy question! Please respond to d...

As Rui and Yuzhou pointed out, you can perform a lookup on the table prior to updating so, if an incomming column is null, you can retrive the last value from the lookup. An alternate solution, outside of DataStage, is to place an update trigger on the table in question to perform similar logic. Suc...

Are source1 and source2 part of the same job? Is source1 an insert and source2 an update? Victoria.A.Oliver-Macklin@gsk.com wrote:Not quite ... I still want to write all the other fields for the record in regardless. I just want to omit that one field if it is null and not overwrite the value alread...

Not quite ... I still want to write all the other fields for the record in regardless. I just want to omit that one field if it is null and not overwrite the value already in the table for that field. Thanks, Vicki "Riccardo Tani" To: datastage-users 16-Jul-2002 cc: 12:09 Subject: Re: A quick and ea...

Hi Victoria, if I have understood your question, you can do this using the output constraints, that is the condition for writing into the output link. Into the transformer stage you can built a constraint for the output link where you test Not(IsNull(linkinput.filed)). You can find more info into "S...

I am writing values into a table from two sources at different times. Is there a way in the transform to check that if a value is null, dont write it? If value is null from source2, I want to not insert it, as source1 may have put a value in that field and I dont want to lose it unless source2 actua...

Hi, If you are working with DS4.2 and later, there should be After and Before tabs into OCI stage where you can perform a statement like ALTER.... Hope this will help you Riccardo ----- Original Message ----- From: To: Sent: Monday, July 15, 2002 9:52 PM Subject: Parallel Dml kin datastage > Hi > > ...

In a perfectly tuned hashed file, it takes exactly ONE read to retrieve a record whose key is known, not two. The design goal when dynamic hashed files were originally implemented was that, allowing for shape changing I/O, each read would require one I/O and writes on average would require 1.1 I/O o...

I have built simple dynamic lookups of 3-4 million rows without incident even on fairly wide tables. At some point you may need to get some help on setting up some creation parameters for the dynamic files that will speed access and make the hash much more efficient. Also, particularly if you think ...

Assuming you are creating server (not mainframe) jobs, every active stage type (such as Transformer stage, Aggregator stage, Pivot stage and so on) has properties called "before-stage subroutine" and "after-stage subroutine". These can be found in the stage properties area (location of which varies ...

Several people have asked about the previously mentioned files download area. At this time, it is completely empty since no one has contributed anything yet. Got any white papers or neat routines you would like to share? You could be the first to have something posted to it! m -- Regards, Clif

Hi I would like to use PARALLEL DML for an update statenment(user defined) within datastage for better oracle performance. In order to do that I need to set the session to parallel. I would like to know the method to put oracle statements in the same OCI stage in Datastage. ALTER SESSION ENABLE PARA...