The orcle write method :LOAD

[karrisuresh]

Hi
I was trying to insert the records from file to oracle table

but
In my previous experience when Ever I want to insert
I used to opt for Upsert(udate and Insert)
I used to give the condition in update as 1=2 ie update can never happen as 1 can never be equal to 2
so this is how I inserted records

Now in my present job i am trying to load records using the write metod :LOAD
but job is getting aborted, the same job is working with upsert and getting aborted with load method

Could any one who has the the experience of using the LOAD method
can suggest me how to over come this prob and load the records into oracle target

thanks
Suresh

[ArndW]

Suresh - could you post your exact error message, there are many possible causes for failure.

[ray.wurlod]

Also please advise what stage type you are using. The answer may be different depending on which it is. I assume, from your subject line, that it's the Orcle Enterprise stage. But please verify.

[karrisuresh]

Hi Suresh Garu,
My source is file and target is oracle
when I am usng the upsert method
the records are getting populated in the target
but when I am using the load method
the job is getting aborted giving the following error

Oracle_Enterprise_2,2: sh: line 1: sqlldr: command not found

The call to sqlldr failed; the return code = 32,512;

Unable to access the log file.

Oracle_Enterprise_2,2: The runLocally() of the operator failed.

pls find the attachment also
thanks

Suresh - could you post your exact error message, there are many possible causes for failure. ...

[karrisuresh]

My source is file and target is oracle
when I am usng the upsert method
the records are getting populated in the target
but when I am using the load method
the job is getting aborted giving the following error
Oracle_Enterprise_2,2: sh: line 1: sqlldr: command not found

The call to sqlldr failed; the return code = 32,512;

Unable to access the log file.

Oracle_Enterprise_2,2: The runLocally() of the operator failed.

thanks

Suresh - could you post your exact error message, there are many possible causes for failure. ...

[karrisuresh]

The stages I am using is seq file(source) transformer and oracle(target stage

Also please advise what stage type you are using. The answer may be different depending on which it is. I assume, from your subject line, that it's the Orcle Enterprise stage. But please verify. ...