us1aslam1us wrote:Need more information. what does the log suggest ? Also does the user have access to the table? Check any constraints on the table.
i m able to insert a row externally using a insert command.
When i m running the Datastage job.......its not loading.
There is no error in the log file.
Its taking a lot of time.
More than 4 hrs............
a) when you run the job, does it show that the correct number of rows were read from the dataset?
b) what method are you using in your Oracle stage?
c) Have you tried adding a reject link to your Oracle stage and analyzing the output?
can you check if all records are getting rejected for some reason, you may not see if, you may have choosen to continue for any reject, change it to ouput.
i was also faced the similar issue.. I didn't noticed the records got rejected while loading into the oracle table due to mismatched datatype between source and target..
1)Put reject file at the oracle stage.
2)Check the datatypes between source and target.