DSXchange

Hi,

If you can change the oracle password - I would suggest you to change it in accordance , else if you are left with no other option , I would suggest you to add the quotes in the parameter values.

Regards
Naveen

hi

Cant we add a transformer and trim the leading "zeros".

Regards
Naveen

hi,

May I know whats the question in the above problem.

Do you want the virtual columns to be populated in the referential integrity detailed report or not?

Regards
Naveen

Hi, There are two ways of executing the script in the unix one with the ./{ScriptName}.sh or you can give sh {ScriptName.sh}..However in Datastage it is better you follow executing using sh followed by name of the script to be executed .. in your case sh /xyz/exist.sh ... pass your file as a paramet...

Hi,

You can find in the metadata definition a property called "Extended" try giving Unicode over there and check whether its working or not.

Regards
Naveen

Hi ,

Doesnt matter whether you sort it or not depends on which aggregate function you are using, however it better to give the results in a sorted manner as input to the aggregate function for performance effective.

Thanks & Regards
Naveen