DSXchange

Hi,

You have to do a Lookup/Join to get the values from database but after that you can use "Remove Duplicates" stage to pick the smallest Date1. For that , in the input of "Remove Duplicate" stage, use a Hash partition on A,B, C and so a sort on Date1.

Regards
~Amitava

Hi,

You can't do this because Basic language does not support PX functions. You can read a dataset file in Unix prompt by ORCHADMIN command.

Regards
Amitava

Hi,

It will overwrite.

Regards
Amitava

Hi,

Give more information anyway.

Regards
Amitava

Hi,

Just go to the Designer and add the repository by clicking right.

Regards
Amitava

Yamini,

The transformer which is under "Processing" of Designer is the Basic transformer. Don't use this one. But the transformer which is under Stage Types -> All -> Processing in the Repository of Designer is a PX one. Use this.

Regards
Amitava

Hi,

You can't do it in PX. You just define the table definition and in the job, create some rejection criteria(like checking value of the first field) so that the first record will be rejected and the rest willbe processed.

Regards
Amitava

Hi,

You have to include the directory in path variable. Otherwise it will not execute.

Regards
Amitava

Hi, You have to kill the process from OS and restart the DataStage. No other option. But from your error message I see a mutex error. Now Mutex error message comes if you have used a Basic Transformer in your PX job. Ascential suggests not to use a Basic Transformer in a PX job. You can use a PX tra...

Hi yaminids,

Check your transformer. If it is a basic transformer then replace it by a PX transformer. Basic transformer gives lot of problem when we use it in PX job.

Regards
Amitava

Hi Akash,

Check the table definition of your flat file with the osh definition. You can find the osh definition by Job Properties window. These two definition should match.

Regards
Amitava

Hi,

Check the transformer. If it is a basic transformer then replace it by a PX transformer.

Regards
Amitava

Hi,

This is happening due to insufficient resource.

Regards
Amitava

Hi,

Give some more information about your job design and error log in details including Warning.

Regards
Amitava

Hi,

To control your job you need to write Job control routine.

Regards
Amitava