DSXchange

Thanks Balaji, loveojha2. :D
Isn't a good sign to follow a Legend.

We have jobs running in parallel.

Got confused. I have deleted the quete in my previous post, to avoid confusion.

Try to search the forum for Datset, fileset, Lookup fileset. All the three files are created by datastage and for datastage. All these files will have a descriptor file this is the contro file, which gives you the information where the actual data file resides. Based on your config file (.apt) the n...

Also check your page size usage and its pattern. Were the job been triggered parallel?
Try to check the same job to run in sequential.
Try to set the Envronmential varialble DISABLE_JOBMON to TRUE. Try for one or two cycle, if dont get any Player termination, pls revert back.

As Kris mentioned, If all the 5 jobs were arranged sequentially with 'OK' trigger, and if 3rd job aborts the JObSequence abort at that stage.
If all were arranged in parallel, All jobs may run (depends) and still sequencer will abort.

Iam not at PX right no, but I am sure, there is a Evnironmental variable, where you can try setting it for time outs.

Still I couldnt understand how you manage to lookup RobDeW with HJ?

Its all because, it orders it collect it in buffer, and hence takes time to consolidate the whole set, and have a quick write.
What does the total time taken for the order by in th query and with out it?

Is your COL1 column marked as NotNull?
If so handle null for that column.
Also try turning Combinabiltiy to false and rerun the job.

Has you Arry Size property been set to 1?

Actually I messed that 'terminology'. Ray is mentioning the terms if (star) schemas.
And he started with Snow flake.

chulett wrote:'conformed'. And he said 'in star schema terminology'.

Missed that

ray.wurlod wrote:In star schema terminology, do the snowflakes first, then the dimensions, and finally the fact tables.

Bit confused
Snoflakes in Star schema? Or mentioned about confirmed dimensions?

Most likely the permission error. If you search for the error, you could find one post from me.
cd $DSHOME
. ./dsevn
bin/uv --> gave the same error. Try to give execute permission to those group.

decimal_form_decimal can be used to convert 38,10 from 10,0. Which can be mapped to int64. You can leverage the implicit conversion by that time.