DSXchange

I'm getting a similar error. Could you please tell me where are the log files located.

Thanks.

Raj

Hi All,

I'm reading about 6 million rows from an Oracle partitoned table in an OCI stage. What is the optimum number for the arraysize to set.

Thanks.

Raj

Hi,

I want to write a PX job the reads data from a partitioned oracle table
and writes an output flat file. What do I need to do to make it read the data in parallel from the partitioned tables.

Thanks.

Raj

Hello All,

I have a job in DataStage that reads from an Oracle table that is on a remote server. What kind of connectivity is it using to connect to Oracle i.e SQL NET , DB LINKS or ODBC ??

Thanks.

Raj

Hi All,

I have a PX job with the data read in from an oracle table.What is the best way to make the oracle stage read in parallel mode. What do you think about hash paritioned oracle tables ? Does oracle hash data the same way as DataStage does ?

Thanks.

Raj

Kenneth,

We are basically an Oracle shop (90%), and are thinking of using Oracle tables not just as reference, but as source data as well. So you don't think this is a great idea ?

Raj

Ken, We are in the process of comparing peformance of reads from partitioned oracle tables versus reading from .ds files. The oracle database is on a remote server. So, we want to mimic this with the .ds by reading from the remote server . Moreover we don't want to be testing on the production serve...

What I mean is that the .ds file is just a pointer to the underlying data files in the DataFiles directory. Do I have to FTP all the underlying files as well.

Thanks.

Raj

Could you please explain how NFS mount works. Any examples will be appreciated.
Also, does the FTP on a .ds file work the same way as a .dat file.

Let me know.

Thanks.

Raj

Hi All,

I have DataStage installed on server A. How can I read the dataset on server B which does not have DataStage installed on it. I also want to be able to write to server B.

Thanks.

Raj

We want to do parallel testing between 20 different .ds files generated from DataStage ver 6.0 to 7.0 for the same batch day. So I need to make sure the data in the 2 sets of files is the same.
Please let me know if you have any more questions.

Thanks.

Raj

Kim,

So what would be your suggestion i.e diff operator or change capture or can you think of anything else.

Let me know.

Thanks.

Raj

Hi All,

What is the most efficient way to compare 2 datasets, apart from the diff and change capture operators in Datastage. Is there any unix command to do that.

Thanks.

Raj

The DB Options Mode is set to Auto-generate. There are 2 columns in the oracle stage, they are : cntrct_id numeric 38 and cntrct_stts_cd varchar2(10). The colour of the link is black. I'm not doing any updates in the oracle stage. Also, I get the following warning "When checking operator: Colum...

Hello All, I have a job that reads from 3 Oracle tables and writes to a flat files with some operators(sort, join & transformer) in between.The data from Oracle goes to a sort operator and then to a join operator. When I run the job it completes successfully. I get the no of rows I'm expecting, ...