DSXchange

Prashantoncyber wrote:Tried by but not fetching proper result.
Looks like need some other approach.

Thanks
Prashant

The approach is correct.
Try

If you are creating a new environment (new project) its the right time to set the auto purge settings in Adminstrator client. As the setting will affect only the newly created job afte that setting. Rathere than fiddling with the script. Yes, I guess that's the best option then. I was hoping I coul...

Is it possible to set the auto-purge of the job log for a project through the command line? I'm trying to make a unix script to set all the project properties in Administrator to make the move to another environment easier. For most properties I can use the dsadmin command, but I don't see any optio...

It's in the scratch directory that is set in your configuration file.
Usually it's something like ../Ascential/DataStage/Scratch

I don't think you will be able to appreciate the parallel capabilities on a 2 cpu server. You probably won't get much performance variation using 1, 2, or 4 node pools that couldn't be attributed to process task switching overhead. What configuration would be "good enough" to see those di...

can you post the cofigurations like partitioning schemes used in your job there are more possibilities but first of all check this The partitioning is all set to default since it's just a test. I don't think that should really make a difference here. I checked the distribution of the data over the ...

Is the data you read in from the csv file and the data you read in from the database table both indeed NULL after you read them in datastage? If you insert a peek stage for both of them and look at the actual values, do they show NULL or may an empty string? For the csv file to regard an empty strin...

Apparently I do have to read the books again. According to the unix operator my first job hardly used any CPU at all (probably it was too busy reading and writing to even need 2 CPU's). Another test jobs that required more processing (sequential file -> column importer -> sort stage -> dataset) appe...

We are having a new server with supposedly 2 processors. I was curious to see the performance difference between running parallel jobs using 1 or 2 processors, so I made a few testjobs and ran them using a 1 /2 /4 node configuration file. I know the nodes don't necessarily correspond to different pr...

Since a few days we're having a new datastage served installed (same version 7.5.1.A as on the old server, but a different machine). When running some jobs on the new server, I'm now and then getting fatal error messages node_node2: Player 3 terminated unexpectedly. main_program: Unexpected terminat...

JoshGeorge wrote:Also add the constraint NOT(IsNull(indata.Col1)) in transformer

Oops, yes, that would be useful too

You can use a stage variable in a transformer to hold the parent value. If you define the stagevariable svParent as: if IsNull(indata.Col1) then indata.Col2 else svParent The value of this variable will change if a new parent record is found, and stay the same if child records are found. Then you ca...

you need to add two extra 'end' statements before the 'else'
So it will be Then it compiles correctly.

you can convert the date to string. Separate the date month and year using Field or any similar function. Now increment the month and concatenate all three. And convert it back to date. Now if the month is 12 then you need to increment the year and the month to 1. Check for that condition before co...

I have seen people say before that you can specify the directory where the files are written like that. But the last time I tried it, you can specify a file , not a directory. In this file you get the sql loader command that would have been executed, which you can then execute yourself, and the file...