DSXchange

Hi,

You have to give more detial...
Like...How you are inserting into table? ..a) load/upsert

Cheers,
Harsha

Check the return code of your unix command.

Unix command executed successfully will return '0', irrespective of your result(wc -l).
I hope this helps to solve the problem.

Hi, Using oracle load method, index=Rebuild. Getting Fatal error : RPM_ITEM_ZONE_PRICE: Oracle call failed; sqlcode = -12801; message: ORA-12801: error signaled in parallel query server P000 ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found But job finished. Finished Job ldEGMY006RPMItemZo...

Hi all, Running one job with Oracle load method with following properties: Method: Append $APT_oracle_load_delimited = , Able to insert the records into the table. I checked the control file of oracle also. But Getting the following warnings for date and decimal columns only: TLOHB_LGCY_ORD_HDR_BFR_...

Hi bugfree,

We cannot execute multiple commands using open or close command.


with regards,
harsha

Not clear. I dont understand your requirement. Where do you want to use this connection information? In a third party tool? Disabling triggers can be done in the open command in the oracle enterprise stage. Regarding load options search for "APT_ORACLE_LOAD_OPTIONS" in the forum here, and...

All, In the project we are using user defined variables in datastage jobs. But in Oracle Load method we have to a) disable the triggers as well, But this option is not present in the oracle Enterprise stage. b) Some of the columns in the table having constraints which refer to the some other column...

All, In the project we are using user defined variables in datastage jobs. But in Oracle Load method we have to a) disable the triggers as well, But this option is not present in the oracle Enterprise stage. b) Some of the columns in the table having constraints which refer to the some other column ...

Hi,

In which file the user defined environment variables defined in director will be stored in datastage?

My requirement is to extract the user defined einvironment variables in Unix using shell script.

with regards,
MCH

Hi ArndW,

Thanks for replay...

Can you please explain me bit more collecting reject records from oracle load method?

thanks and regards
MCH

Hi ,

I am using oracle load method to load 140 million records.

a) Is there any way i can get the rejected records from the oracle enterprise stage?

b) To improve the performance what are all the things i have to take care

thanks and regards,
MCH

Hi,

It would be great if you just give me the document name the ascential datastage provides...to refer the creation of mapping file..

thanks
MCH

mc_harsha wrote:Thanks for response :D

Entry:

ISO8859-1 WE8ISO8859P1 in oracle_cs.txt

Is this right??

with regards,
MCH

Thanks for response :D

Entry:

ISO8859-1 WE8ISO8859P1 in oracle_cs.txt

Is this right??

with regards,
MCH

Hi All, Running the Load method job using Oracle Enterprise stage. Set values: NLS_LANG=AMERICAN_AMERICA.UTF8 Error Message: main_program: An NLS character map <ISO8859-1> is specified, but no entry was found in $APT_ORCHHOME/etc/oracle_cs.txt. The entries in oracl_cs.txt are UTF-8 UTF8 UTF-16 AL16U...

:D thanks for your answer....