DSXchange

What does OshExecuter.sh does ?

Hi All, I am facing a strange error, which is aborting my jobs. The log file shows "Parallel job reports failure (code Internal error - missing script file RT_SC35/OshExecuter.sh)" I am running few jobs in sequence and sometimes this error occurs and job aborts. If you rerun the job again ...

I have a buildop doing certain caluculation on an input with aprox 5-6 million od data. In my buildop i am running a loop with 1500 iterations, for each input record. The time this job takes is quiet high. Is there any way of reducing this time? any optimization suggested while working with buildops?

"You could use the counter with the Stage Variable." ...seems to be most tempting and easy solution. But this will blow up as u add configuration file to ur job(which u will). Just add 2*2 or 4*4 config file and c the result.

as Teej said its recom. to hv hash partitioning on the keys.
And i think its better to hv the lookup fields sorted(although its not necessary for DS) . U can use the perform sort checkbox for the same in partitioning sheet .

Thanx Teej,

That is what i have done but dont u think it will make process lil slow.

I thought of writing one single server job, in between my parallel jobs, for these kind of conversions, but then one will miss out the crux of PX.

Regards,
Praj

Hi, How do we handle date conversions in PX? For server jobs, we can use iconv and oconv but in PX theres no such option. So then how to handle dates which are not in standard formats? For ex: if you have a date like 24-dec-2003, there is no way but to have a file with dec->12 mapping and using this...

Once u r in bin dir under DSEngine use the command
dsjob -run -param <parameters list> -jobstatus <project name> <Jobname>

Regards,
Praj

The problem is i am not able to downld the Parameter manager client component from the link above.
Has anybody tried dwnlding that before?

Is nebody using Parameter Manager? how good it is?
I tried to download the client component from http://www.datastagexchange.com/PM/ but no success
ne pointers

I dont think u can call a routine in a Px job transformer.
We can do the same in server.
One thing you can do is move the values in the routine to stage variable and use them in Xmer

I am running a PX job creating multiple datasets from a seq file using a Xmer. The input has millions of records. Now when i run this job for the first time, there was no problem but when i rerun that job changing input and without recompiling job it aborted. if i compile the job, it works. The erro...

thanx a lot
It worked perfectly

Hi all, I am reading a datetime as a string(since, not able to read it as a timestamp in DS) from a text file e.g. "23-OCT-03 01:28:28". Now i need to convert this into a timestamp with format <yyyy-mm-dd hh:nn:ss> e.g. "2003-10-23 01:28:28". I have tried string to timestamp conv...