DSXchange

What is the NLS setting to be used in parallel job to allow Latin 1 and Latin 9 characters while extracting and loading to SQL server 2005 Database. We tried with option ISO-8859-1 , ISO-8859-15 , UTF-8 for NLS but there was no result, When we tried with server job as mentioned in the below post, la...

Hi, I my project we are using more number of datasets, to have a good extraction and faster performance for job execution. But, I would like to know your comments for the below cases. If the dataset allocated memory in Datastage server reaches to the maximum limit or 90%, what would be the performan...

Hi All,
Need input for this requirement, in which we need to have a source query in any file can say configuration file for the job, from which need to pass the query to ODBC stage instead of hardcode the query in ODBC stage itself.

Thanks,
Kannan

Hi, Thanks for your reply, I have checked the Oracle DB having NLS settings as like below "Select * from nls_database_parameters" NLS_CHARACTERSET AL32UTF8 The characters were not displaying even when the data has been viewed from Oracle enterprise stage it self. it would be more helpful i...

Hi All, Earlier i loaded data with OBDC stage and loaded in sql server. Now for performance tuning i replaced ODBC with Oracle Enterprise stage. I'm able to load data but it is not supporting the latin characters. For example (') apostrophe is reflected as question mark(?). I have tried all options ...

Any one tried to attach a file in an email notification using DS routine, please share your suggestions or code.

Try without using StringtoDecimal function,


Source column Datatype as (Oracle) ---> Varchar2
TX ---> Decimal(38,2)
Target column Datatype as ---> Decimal(38,2)

Try the above suggestion and let me know

Please share the steps to follow to connect latest version of Progress databases using Datastage stages.