DSXchange

Yes, The dataset was created using the same configuration file. There was no porting done, across projects or systems. Well, while porting the projects, from dev to test/ prdn., checking on the configuration file, and to maintain consistencies will avoid any such errors. But my problem was that, it ...

Hi,
You might want to try this:
In the constraints of the lookup stage, choose the "multiple rows returned from link" on the reference link that might be returning multiple values.

Hi T42, Here is my configuration file. The problem has been fixed, with the error being "not specifying the server name in the Oracle Enterprise Stage". { node "node0" { fastname "DBPU2" pools "" resource disk "/opt/tempdataset/" {pools ""}...

Thanks,
Not specifying the remote server has been the error.
It was done in the prior job, which loaded the table, but not in this job..Hence the error.
But, the error message a bit confusing in this regard..!!

Hi Ray, Can you please shed some more light on this. Actually, I am able to load the same dataset into a sequential file. When i try to load the table using either sequential file or dataset, i hit this error. The Parallel startup is not happening while loading into the table only. Thanks in anticip...

Hi, I have a set of around 74 K records in a dataset, which i have to insert into a new table. When i try to run a parallel job, that has a Dataset(source), Transformer and a target Oracle table, I get the following errors from the director: main_program: APT_PMConnectionRecord::start: waitpid(18708...

Hi, I am trying to load data from datasets into oracle table using Oracle Enterprise stage. I have Not null data, as Null values in the datasets. I tried to capture the rejected records by using the reject link to a sequential file, and also by having a REJECTED code in the constraints to a sequenti...

I guess i would have to ask the DBA about changing it to number. Yes, there would be numbers which would be hitting 10 places. And more importantly, the target database is based on a front-end application design. Hence the requirement to stick to the definition provided.

Thank You guys.

Hi, I am trying to create a new table and load the data from another source table. Source table has 2 columns as a Decimal(10,0) b Decimal(10,2) to create the target table, when i import this schema, i get a BigInt b Decimal(10,2). So, in effect the target table definition for column a becomes Numbe...

Hi, I am testing the performance by loading a table using Oracle Enterprise stage, and ODBC using dynamic RDBMS. The testing is with datasets having 4.4 million records and 20 columns. I am able to load the dataset into Oracle table 'TEST' using the Oracle enterprise stage, which is taking around 5 ...

Hi, The Installation documentation for Datastage Enterprise Edition says that it is a pre-requisite to have C++ compiler for developing the parallel jobs. And it suggests either SunPro C++ 6.0 or SunOne 7. Apparently our vendor for C++ says that SunOne 7 is EOL -ed, and has suggested us to take Sun ...

We will be using DS 7.5 on unix for a conversion project. The total number of jobs developed could run into 800-1000. The entire conversion process is categorized into subject areas, and each subject area contains a number of tables which are to be populated based on a loading sequence. we are still...