DSXchange

I have corrected it Naveen. Thanks. But as I mentioned, My problem still continues with the rows for the column whose datatype is number. Is there a way out for that. I seem to miss it. I am still waiting....

Kris

If you double click the event detail for Environment variable settings in your job log in the director you should be able to see the username. If thats what you are looking for??


-Kris

Hi Naveen, Thanks for that. It worked fine for columns whose datatype is varchar2 but didnt work for column whose datatype is number. Am I missing something out over here. please let me know. And as Kumar mentioned..NULL is different from empty string. But I need NULL at my ouput..so I used 'NULL' i...

Hi all, I have created a simple job that reads data from the source table through ODBC stage and writes it to an Oracle target table( I am using a OCI stage) through a transformer. The only transformation I do in the transformer is to find out if there are any empty spaces in the source table and wr...