Unable to load into a Table from a dataset.............

[pavans]

Hi ,

I have a dataset with 4 lac reocrds.
i am loading to a oracle table.
there is no transforamtion....involved.

But.......i m unable to load a single record.
the table is also empty.
Awating ur reply.

Thanks in advance........

[us1aslam1us]

Need more information. what does the log suggest ? Also does the user have access to the table? Check any constraints on the table.

[pavans]

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............

[us1aslam1us]

First check you APT_ORACLE_LOAD_OPTIONS environment variable. If still problem persists then discuss this with your DBA.

[ray.wurlod]

How was the Data Set created? Does the job that reads from it use the same configuration file as the one that created it?

[pavans]

First check you APT_ORACLE_LOAD_OPTIONS environment variable. If still problem persists then discuss this with your DBA.

I have checked APT_ORACLE_LOAD_OPTIONS, there is no value for it.

[ArndW]

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?

[keshav0307]

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.

[say2prabhu1]

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.