DSXchange

Use TO_CHAR function:
TO_CHAR(ColumnName, 'DD-MON-YYYY') )

Thanks

It does not make sense to get same 2 columns. Anyway, you may map source column to both target column.

Thanks

Parameter Set helps you reuse the whole set and when you need to change you only change in one place instead of every job.

Thanks

Use Excep_ErrorHandling and Terminator_Activity stages in sequence. If any exception happens it will stop the job.

Thanks

You could define those values in User Define Variable[project level] at DataStage Admin.

Thanks

Use transformer sate and stage variable.

Thanks

I don't think so. You have to specify those columns.

Thanks

Remove hypens from the date format make it yyyy%mm%dd"

Thanks

If you click Help on DataStage Designer and click "About DataStage Designer", it will popup about Version, Build Number and Other info. At the bottom of the popup there is a clickable , "Show Patch Install History". You may click that get the history [I am talking about DataStage...

Did you mapped ChangeCode() to output column?

Thanks

Use Execute Command stage in Sequence and use wc -l filename command to get the total count.

Thanks

Keep trying. Use corp2corp, monster, dice job portals. Good luck!

You may try this:
If Trim(Column_Name) = '' Then '' Else Trim(Column_Name)