DSXchange

Hi, We need to use the Parallel Extender facility (Enterprise Edition) to read a huge table and create multiple flatfiles. Later we need the data in these flat files to be written to another table in another database. Is it possible to create multiple flatfiles (out of the data read from a table) in...

Hi, Recently, when we were presenting a DataStage solution which contains a simple Oracle to Oracle load of a large table, we were bombarded with a question saying that there could be insertion issues. And their argument is that because of those issues, if the "write" fails, then we need t...

Hi, I need to load a Oracle table of 20 million rows to another Oracle table. My server is a 4 CPU machine. May I know how the use of Parallel Extender (or Enterrpise Edition) will be advantageous? I need to know how the rows are processed to impress upon the need for using the Enterprise Edition. C...

Hi, I have the following scenario. I have one sequence containing about 20 jobs. Each job loads one table from source to the target. I need to specify the connection parameters (Oracle username and password) in every job. I want to mention the parameters only once in the sequence and it needs to be ...

Hi, I used to run jobs with the server installed on my local machine. They were running properly. Later, when I tried to run the same job on the server, I'm getting the error: ds_loadlibrary: error in dlopen - Dynamic Error I could understand that this is something to do with the installation. Can y...

Friends, While trying to run a job to load data from a source table to a staging table, I encountered the following error: "LOAD_PS_RBT_ACCOUNT..Transform_PS_RBT_ACCOUNT: Oracle Error - OCI_INVALID_HANDLE" LOAD_PS_RBT_ACCOUNT is the job name. Transform_PS_RBT_ACCOUNT is the transformation ...