Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to load data from Sybase to oracle Database which gets loaded successfully when I do it with normal tDBoutput however I have to load millions of rows so I thought of using tDBoutputbulkexecute component. but getting an error as
Exception in component tDBOutputBulkExec
java.lang.NullPointerException
Please advise.
P.S. Both of my databases are running on different servers.
Cloud you please share the screen sot of the Job Design.? If the error is in output component the try running the records with "Limit". then you can find where exactly the error is.
If this is what you are looking for then, Press the "Accept as Solution " Button. Give A Kudos
Thanks,
AR
Hi AR,
Thanks for your reply. attached is my job design. is this issue happening because my source Sybase is on different server and oracle database where I am loading data is on different. if so what is the alternative to overcome this issue so I can load millions of rows quickly into oracle/
thanks,
Prashant