DSXchange

I have transformed only 3 columns out of 10 columns in a table and i want to update only those three columns in the table. I don't have any key columns in the table. I there a way that i can do this without messing other columns. currently i am doing truncate and load the whole table since i don't h...

sorry oracle 11g version. to be clear

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

7.5 version on win 2003 server, by the way what is PITA?

thanks for the info...it is working.

I have a job that reads a oracle table which contains "long" type column, but when i imported the table definition it is shown as "longnvarchar". When i try to view data or try to run the job i get the following error: main_program: Internal Error: (colDesc):orautils.C: 1655: get...

Thanks for your reply. I can add it as you said, but where i have to use this parameter in the Oracle Enterprise Stage in order to avoid the problem.

Can anybody tell me where i can add this environment variable APT_ORACLE_NO_OPS (set the value to 1), I am trying to access a RAC database and i am getting an error

Can anybody tell me where i can add this environment variable APT_ORACLE_NO_OPS (set the value to 1), I am trying to access a RAC database and i am getting an error

The datastage is not installed on the remote server, there is only oracle database installed on it, which i need to access. They have the following setup: OS is Red Had 4.5 Database is Oracle 11.1.06 DB running on 3 Nodes Instead of running the jobs on our (windows 2003 having 4 processors) server, ...

can some one please tell me where the problem is. My c++ routine is compiling without any problem from visual studio. But not compiling in the transformer. Please let me know: Output from transformer compilation follows: ##I TFCN 000001 15:21:14(000) <main_program> Ascential DataStage(tm) Enterprise...

Hi I am planning to create some parallel jobs on windows 2003 server. The oracle database is the source and target. The database is on unix. Can i take the advantage of running the jobs on their hardware? In the future we want to turnover the project to the database team. So will that be helpful? Ca...

change the object file .obj to .o and try and also don't forget to include stdlib.h in the routine. As per my experience.....even it compiles in windows it won't work in datastage without this library.

Hi lstsaur, Thanks for replying to my posts. I will give the example xsd and xml file that i used to create sample server job( seqfile----->xml i/p------->seqfile). I created the table definition with xsd file and i used xml file as input in the job. Below are the xsd and xml file. Please let me kno...

The following are descriptions for the columns in the o/p seq file: /shiporder /shiporder/@orderid /shiporder/orderperson/text() /shiporder/shipto/name/text() /shiporder/shipto/address/text() /shiporder/shipto/city/text() /shiporder/shipto/country/text() /shiporder/item/title/text() /shiporder/item/...

Hi lstsaur....i am following your idea of creating a server job. the job is running without any errors. It is showing that some rows processed between i/p seq file and xml i/p stage but shows zero rows between xml i/p stage and o/p seq file. I am getting the following warning: XmlTest_server..XML_In...