DSXchange

Most recently i have this problem as well. Im using a csv file with deliminator of comma & double quote (""). With few testing of the deliminator, there is a way to handle this : --If you are using double quote(" "), then inside the data musn't contain any DOUBLE quote as it ...

Im trying to INSERT value from Sequential file to Oracle9i using method UPSERT.

For UPSERT method, it should only insert data that does not exist in the database.

My problem is, why it INSERT duplicate value into the database when i rerun it again?

Plz help!?

Im trying to load a 23,222KB of sequential source file to the Oracle9i. While running, it prompt me an error: oraS_AGNTPF_VEN3,0: Export failed oraS_AGNTPF_VEN3,0: write() failed: Broken pipe APT_CombinedOperatorController(1),0: Operator's runLocally() failed APT_CombinedOperatorController(1),0: Ope...

I can run it and this error came out : oraS_AGNTPF_VEN3,0: Export failed oraS_AGNTPF_VEN3,0: write() failed: Broken pipe APT_CombinedOperatorController(1),0: Operator's runLocally() failed APT_CombinedOperatorController(1),0: Operator terminated abnormally: runLocally did not return APT_StatusOk Can...

I'm trying to load a *.csv file to the server from DATA STAGE.

The status is "Parallel job reports successful completion"... but when i check in the Oracle9i server, there's no data appear.

The codition of the upload is UPDATE is exist else INSERT.