DSXchange

Write the unix script you can export the jobs to folderwise

In String how to define precision and scale.String property have precision only,You can use ltrim (input column).

Copy stage the output is >1 give the property False Else set TRue.

First time run the job no records in scd stage reference table, then second run on the job the records load into reference table.shoud scd stage reference table in create mode

First conform with your Administrator to get coonection then you can use db2 connector stage.

Give same order of columns both the scd stage. check surrogate key given properly

You can check the corrsponding file names in the unix using ls commend

[quote="nandela.sudheer"]how can i generate a sequence number in parallel jobs[/quote]



Using surrogate generaator stage

In datastage Partioning and nodes is different concepts.
The job can be partioned into seven types ,Nodes is reduce the time given for nodes

Hi
how to handle nulls in source level

In unix read project environment variables