DSXchange

Thanks Ray.world..

As u said we always strive to create jobs that do not abort , but unfortunately our requirement is quite opposite for a particular(single job).



Once again thanks for your helpul guidence.....


regards
Sai

Hi All,

Please guide me about how to abort or fail a PX job based on particular condition not mets in the source file data while job is running .

As in server jobs we have facility to useUtilityWarningToLog . Same way is there any facility available in PX jobs?



regards
Sai

Above Casestudy can be solved by using stage variables/routines Job flow will be as below: source----->sort stage---->transformer----target Above in the Sort stage do sort the start_date as desc, contrid as asc(based on the key columns). In XFM use the stagevariables accordingly .............. *Note...

Hi All, In sequential file(source) ,one of the column is of varchar adatatype and sample data comimg is 071109 which represents 07 is year,11 is month ,09 is day. The requirement is to load the above column data into oracle table and the dataype is timestamp in table. Case: 1 Using ----StringToTimes...

Hi all, How to implement the below mentioned in PX job using OCI/..which satges In server job a hash file created from table(AMALGT) is been used in a particular job as lookup hash file and also the same hash file as one of the target for inserting new found datafrom aparticular field.(i.e used dyna...