DSXchange

Experts, We are migrating jobs from v7.5 to v9.1. Job Design in v7.5 --------------------- update Dataset ---> Transformer ----> DB2 PX Stage Job Design in v9.1 --------------------- update Dataset ---> Transformer ----> DB2 connector Stage (we updraged the DB2 stage to Connector in v9.1) Update Sta...

If it is a multi instance job. you will not see the performance statistics.

Experts, Please help me to design a parallel job for the below scenario. Source: ------------------------------------------- H|file1.txt|20130526 D|123|456|789|012 D|345|678|901|234 . . T|0987 H|file2.txt|20130526 D|000|56W|789|Q12 D|000|67E|9E1|W34 . . T|1234 ---------------------------------------...

use three stage variable.
sv1: validate date
sv2: validate time
sv3: validate micro seconds.

in lookup stage-> constraints-> select the column in multiple rows returned drop down list. this will solve ur problem.

This forum is not for giving complements

If your source is database...
better you can write a query for fetching records of that range.. from database

use column export stage

chulett wrote:How exactly did you use it? That is what you want after all, the absolute value. ...

you can use fabs function...it converts negative to positive

already i have all those details provided by my company....
but am getting some problems while trying to attach a new project....
so pls help....

in aggregator stage use this option... ur performance may increase

METHOD=Hash

Convert function can be used...
convert('&','&',DsLink)

can any one provide me the below details for installing DS7.5...Thanks in advance.... Datastage server: Serial Number: CPU Count: Expiration Date: Enterprise Edition Code: Server Code: MVS Edition Code: RTI Agent: AS Integration: IMS Source: DataStage Client: Serial Number: User Limit: Expiration Da...

Find the second day transaction amount for a Accnt_id. Ex: Epected records are marked in red. Acct_Hist Accnt_id, Trans_Dt, Seq_Num 1001 23-10-09 1 1001 24-10-09 1 1001 25-10-09 1 1002 26-10-09 1 1002 27-10-09 1 1002 27-10-09 2 1002 28-10-09 1 Output: Accnt_id, Trans_Dt ,Seq_Num 1001 24-10-09 1 1002...