DSXchange

Use this in Beforejob subroutine or in FilterCommand in you sequential stage to strip out both header and trailer.

Awesome!!!
Great work with consistent effort. With many smileys. :D
Actual wishes for Homepage count and advance wishes for Actual count.

If you are bothered about additional overhead, use message handler, else use NVL in the database stage to convert the null to a value and nullableFieldValue to convert back the specified value to null.

Use the corresponding APT* environmental variable to avoid the auto insertion of sort in the job. The same has been discussed some days back. I belive Balaji was also in parft of it. If an explicit sort stage is not ther ein a a job where a Join stage is used, the job will likely to insert a tsort i...

I dont find any reason to add an additional dummy row. The last row in the group should have all the concatinated value.

Server editon Sequential file is more polite in accepting the nulls when it has delimiter.

D:/tar/xml/xmlct.xml - Is this the same file you mentioned in both Input XML stage and output XML stage?

Hi Vasu,
You havent mentioned what happened when you run the job alone (without the Jobsequence which holds the $PROJDEF - Which I assuem from your explaination.)

Below is my source, and I need to concatenate col03 based on Col01 and Col02. But I couldnt see any Col2 in your example. If it is simple concatination, you can acheive using transformer. Sort baseded on Col1. Use stage variable to check for repeated value in Col1, and based on that, concatinate th...

Also check through out the links including transformer.
Turn off RCP.
Try using NullToValue() and set null again for null values.
What is the datatype?

Or the similar option available in Transformer.
I always miss those APT* variable with the given huge list.

$POJECTDEF - Hope this is given by mistake. It suppose to be $PROJDEF.
Try to run the current job, you can know what's the value of the parameter been passed. By that way you can easlily ensure, whether the project level parameter is been passed.

Property of the decimal datatype is to preceed 0's with its field length. If you dont wish to get zero, use number or varchar.
As mentioned, dont bother about view data, check the target data.

Check your delimeter.

Try a run with APT_Combine_Operator = 'FALSE'.