DSXchange

Or is it a standard plug in ?

Similar question

Hi Andrw,

Yes, but the number of streams vary each time and the job needs to create the files on the run based on the source XML file, is it possible ?

Based on the source file which is an XML file, I need to create n number of output files using XSLT or other ideas. Does any one have experience doing that or can we not create files dynamically on the run based on the source data.

Does each job create on Message Handler ? I can test this, but do not have the access yet !

Thats what is happening on my end , I used SetNull() still it turns up to be 0!

I need to pass a Null value intoa float field, the solution you have mentioned is to detect Null values I believe.

Hi,

If we cannot use @Null, how do we pass a null into a float field?. I have tried to sue SetNull() and doesnt work.

You can go to the row properties and set the values.

I do the concatenation after a couple of lookups so cannot do it in the Source stage and also would avoid it that way, so that the logic is presented in DataStage.
Will try the Column generator and let you guys know.

Hi,
If I have to concatenate or say insert constant valus in some columns before loading into Oracle , is using the transformer the only option or do we have any light stages than the transformer.

Thanks,

I had a smilar issue and had to use ltrim inthe Oracle stage (Source) !

Use the env variable "Oracle commit row interval" , search for t and set the value , the default is 5000

Hi Craig, I can use a lookup to bifurcate into 2 links , one for update and one for insert but the target has close to 10 million rows and I am sure its not a easy lookup. Basically we have record_dreate_date and record_update_date, I do not want th estage to update record_create_date when it is rea...

It was a syntax issue I guess, it worked when every thing in in one line !
Appreciate your time.