DSXchange

Use any key based partitioning method.

Its 3300-3301 in my environment too.

you can probably put all the values in a file and use that file in user variable activity.

You can use a pivot stage to this.

in the derivation tab give Col1,Col2,Col3.

Can you post your ample XML source file and the required target sample file.

Instead of setting it to NULL set it to something like 09/09/9999

Try using the APT_DISABLE_COMBINATION environment variable in your job and set it to false. You will get to know what the actual error is.

Hi, I am getting the following Compile error. ##I TFPA 000028 06:18:40(007) <main_program> APT Startup script: /apps/Ascential/DataStage/PXEngine/etc/startup.apt ##I TFPM 000326 06:18:41(000) <APT_LicenseCheckOp in APT_LicenseOperator,0> Heap growth during runLocally(): 0 bytes ##I TFPM 000326 06:18...

You should be able to do it by using the Trim(Columnname) function.

try this.

go to $DSHOME

run the following commands

1: uv
2: LOGTO <PROJECT NAME>
3: SELECT * FROM DS_JOBS WHERE NAME='JOB NO1';

You might have to run DS.REINDEX ALL

Try to build teh xml using a Transformer stage with if else conditions.

Right Click on the designer screen and click on show performance statastics.