DSXchange

Thanks for your reply.

nitkuar wrote:

Also you have mentioned that in Oracle you are able to see blank values. Are you sure that those are NULL values or they could be empty strings as well?

Yes, I execute the query with condition as Where ADDR_1 Is null in oracle database. It returned many records.

I defined a source as a sequential file where one column is set as Nullable "No". The data is coming correctly. But when I load the data into database, I can see some null values. (The data is being loaded as the column is defined as nullable in database oracle). So I want to replace the n...

Thanks Ray... I was worried that, something wrong in the installation. As of now, I cannot go for upgrade. I will use the trace options to debug as suggested for parallel jobs. Ramesh -- You were saying that, we need to enable those variables. I did enable. But I don't see any changes or debug optio...

Hi,

I couldn't fine any "Debug" option in my menu to debug jobs.

I am having admin rights.

Thanks a lot friends.

Within minutes I posted my problem to DSXCHANGE, my problem got solved which is not being solved for 2 days.

I found that, some how the table name is wrongly updated in the statements. Now I updated the query manually. Its working fine now.

Hi, I am trying to connect to oracle database as source or target. But I am not succeeded in that. I created a sample job where I want to read data from a file and load it into database using ODBC connection. Here are the steps which I did: 1. Created ODBC connection 2. Created sequential file table...