DSXchange

In DS Designer under the "File", there is an option called "Generate Reports", Using this you can get in HTML page. Inthat if any derivation is used in the transformer it will show as it is in the job. Simply passed column will go as such. Copy those derivations and paste in word...

Hi, In the DS Manager there is in build transform to check whether the input date is valid one or not. Go to Transforms--> SDK-->Date-->Generic. In this you have transform name "DateGenericIsDate". Using this you can check whether the input date is recognised as valid or not. Returns 1 if ...

Check the delimiter that you have given in the Sequential file... Change that and try again

Hi,

You have mentioned that you are not able to view the file using the sequentia stage itself.Better try to divide the file into smaller size and try running the job...

Hi,
Check whether required space is available in the server to execute the job.

Hi,
Check whether required space is available to execute the job.

The target column for that source column may be non nullable... hence if you try to insert with the null values it wont accept. you need to convert it into a varchar "". In transformer you can add the express ion to that column as if source_file.column_a=@null then '' else source_file.colu...

Hi,

First convert the input date column to internal date using the iconv function. It will return a number. Then add 180 to this internal date and using oconv function convert it to the external date format.

Hope this will help you.

Thanks.
Romy

Hi Sometimes if you are geiven the default parameters in your job as 4, but you need only three parameters and pass only those 3 parameters from the UNIX script, then it wont work fine. Check the name of the parameter that you given in the parameter tab with that of the unix script. it is case sensi...

Hi Sometimes if you are geiven the default parameters in your job as 4, but you need only three parameters and pass only those 3 parameters from the UNIX script, then it wont work fine. Check the name of the parameter that you given in the parameter tab with that of the unix script. it is case sensi...

Hi,

I am not sure whether you are using any index in the target table. If so drop it, insert the data and then re create the index again. It may improve the performance.