DSXchange

compile the job and check the test connect then view the data i will work

Use Timestamp data type and use function in transformer stage DatetoTimestamp(ColumnName)

use In lookup Multi link it will give all records from Primary and ref

use In lookup Multi link it will give all records from Primary and ref

use In lookup Multi link it will give all records from Primary and ref

have you used any transformer Stage .Problem is if any transformer stage used in job it wil take more time do compiling because of transformer stage need to C++ compiler.

You can convert file and you can do

Your using sort stage so i will use tem are for operaction so you should check space and your using NFS mount point so and problem in connection check it.

Use UNIX command before us the file
sed "1d;\$d" <FileName>

It will remove the header and trailer records from file

Use UNIX command before us the file
sed "1d;\$d" <FileName>

It will remove the header and trailer records from file

Use loading as sequential method

check the environments setting between to servers.

Use VARCHAR 19

You Can Use NUM function

Use Substring [1,10]