DSXchange

When i am exporting to a flat file, its not giving the complete dump. How to get it?

Hi, I have done Column analysis on a table for few columns. I am trying to genarate All frequency Distribution report on that table. The maximun number of column values iam getting for a particular field are 32000. When i ran a SQL query on that particluar column, i am getting more than 32000 column...

I am trying to run a extraction sequence and this seqeunce is getting aborted due to the below error in one of the job. The current soft limit on the data segment (heap) size (2147483645) is less than the hard limit (2147483647), consider increasing the heap size limit. Details of the aborting job: ...

Hi, In our project we have requirement to extract data from Lotus notes. We do not have ODBC driver installed for lotus notes. In this case, is there any possibility to extract data from lotus notes and put into oracle (may not use data stage). I do not know any thing about lotus notes. Please do he...

Thanks for your reply Ray, But I am not able to find any values that we can set the NLS disable in the oracle stage, There are lot of other codes available Can anyone let me know which one I have to select to make the NLS Character disabeld.

NLS is enabled for my project. How to override the project level settings at job level to make NLS disabled.

We are giving the table name in Read method in Oracle Stage and not defining any columns expecting it will pick all the columns of the table and propagate, It is working but only issue is it is making all the varachar columns as Nvarchar.

We are giving the table name in Read method in Oracle Stage and not defining any columns expecting it will pick all the columns of the table and propagate, It is working but only issue is it is making all the varachar columns as Nvarchar.

Hi,

When i am using Run Time Column propagation, all the columns having data type VARCHAR are converting to NVARCHAR. I do not want to convert the datatype.

I need to stop this in job level not in administrator level. Is it possible? Please let me know.

Thanks,
Sreeram