DSXchange

Hi,

From your error message I think your database table partition and datastage partition are not same. Just change the partition type to DB2 if your database is DB2 otherwise use "Hash" partition. Don't use "Same".

Regards
Amitava

Hi,

Define your job parameters again. This might be due to metadata error.

Regards
Amitava

Hi,

If you are designing jobs in PX environment, don't use any basic function which are used in server version like DIGIT etc. It will minimize the efficiency of your program. Use Convert function in PX Transformer. The syntax is available in the help.

Regards
Amitava

Hi,

You can do it very easily. Put your source of data first then put a sequence generator stage, generate sequence from 1 for each of the records. Then sort the records in decending order. You will get the desire result.

Thanks
Amitava

Hi,

You have to handle null when a null value is coming through a not null field. You can use a transformer and use the IsNull() function within the transformer to check the null value in the field. If it is null then handle the null.


Regards
Amitava

Hi,

I have worked in both of them. Feature wise DataStage offers lot more but I am not sure how many of them really works or works perfectly because we have opened a lot of tickets to Ascential but yet to receive any concrete solution for many of them.

Regards
Amitava

Hi,

I have worked in both of them. I feature wise DataStage offers lot more but I am not sure how many of them really works or works perfectly because we have opened a lot of tickets to Ascential but yet to receive any concrete solution for many of them.

Regards
Amitava

Hi,

You can use "StringToDate()" function in a PX Transformer to convert the string to a "Date" type variable. Use help for the syntax.

Regards
Amitava

Hi,

You can use the query like this

select * from <table name> where <date> between current date -7 days and Current date;

Regards
Amitava

Hi, Use two input database stage (for example if your database is DB2 then use 2 DB2 enterprise stage) for each of the tables, use a join stage whose inputs will be the previous two database stages and in join stage input section, use 'entire' partitioning method if your tables are small or use 'has...

Hi,

Do not use @INPUTROW in PX partitioned jobs because the value of @INPUTROW will be different in different partition. You can use Surrogate key Generator stage to create a runtime number. It is consistent across the partition.

Also you can control the commit level in DB2 stage.

Regards
Amitava

Hi,

DB2 Enterprise stage will give you better performance. Also you can use the 'UPSERT' feature of DB2 Enterprise stage to load data into database.

Regards
Amitava

Hi,

Don't use 'Basic Transformer' in PX jobs to avoid mutex error.

Regards
Amitava

Hi,, To eliminate this mutex error, instead of using a Basic Transformer you have to use PX Transformer.. But you can't call a basic routine from PX Transformer.. You can call a PX routine(unix shared library) from a PX transformer.. Otherwise you can create and use your own buildop.. Regards Amitav...

Hi,,

There is no feature to restart job in 7.0.1.. You have to write your own logic to restart your job.. You can use DSPrepareJob function in batch program..

Regards
Amitava