DSXchange

no specific warnings relating to the o/p stage...just iam getting normal warnings 1. main_program: An NLS map <ISO-8859-1> is specified, but NLS_LANG is not set. The NLS map must be set to an ICU codepage which is equivalent to the character set specified by NLS_LANG 2.main_program: An NLS map <ISO-...

can u tell me how can we use the upsert mode on the o/p side (oracle stage) . iam not able to update and all the rows are getting rejected.

1.Oracle_Enterprise_2,0: SQL*Loader-500: Unable to open file (\\.\pipe\ora.924.267000d.fifo.0) 2.Oracle_Enterprise_2,0: SQL*Loader-553: file not found 3.Oracle_Enterprise_2,0: SQL*Loader-509: System error: The system cannot find the file specified. 4.Oracle_Enterprise_2,0: Call to sqlldr failed. Ret...

i have a table in the oracle database. i want to do a transformation on one column of that table and load back into the same table with the same job. that means i have to give the same table name in the oracle stage properties for the i/p and o/p. I want to know whether it works or not?

I have i/p oracle stage connected to transformer and then o/p oracle stage. Is it possible to use the same table as the source(i/p) and target(o/p)?. I tried it, but it is giving errors. I want to overwrite the records in the table after the transformation

the problem has solved for me (not sure if it is a permanent solution). what i have done is, after changing the oracle home from 9i to 8i, i have added an environment variable for windows 2003 server with name TNS_ADMIN with value pointing to ORACLE_HOME/network/admin of 8i, and it has worked. i.e.,...

i have to create a new table in the target database, so i am using load and create method. i am not using upsert method.

the source and target databases are oracle 8i and i have oracle 9i client on datastage server. I read in dsxchange, it is not advisable to use oracle 9i client to connect oracle 8i database in datastage perspective( to use oracle enterprise stage). I was able to read from source but when trying to w...

i have restarted the server ....but still it has the same issue.

craig, there is nobody to help me. we dont have support from IBM? There is no datastage administrator.

craig....i just want to know how datastage looks for the TNS names. For example i have 2 TNSService names in oracle 9i home and 2 TNSService names in oracle 8i home. I am giving the remote server name as a TNSService name from oracle 8i home...but i feel it is still looking in oracle 9i home. and gi...

i have closed the designer and reopened.....should i reboot the windows server after changing the oracle home?

when i try to view data it is giving as tns name error. but it is not the case....because i was able to connect sqlplus with same tns name.
please give me the possible solution.

i have 2 oracle clients (8.1.7 and 9.2.0) on datastage server to connect a remote oracle 8i server. i have installed oracle 9i client and then i have installed oracle 8i client each having diffrerent oracle homes. Since it is pointed to oracle 9i home (since it is the first installed), i have change...

I have installed oracle 9i client on datastage server for setting up ODBC connections to the remote oracle servers. the remote servers has running oracle 8i on them. what iam doing is iam connectiong to a source oracle 8i database with ORACLE STAGE and loading to target oracle 8i database with ORACL...