DSXchange

Thanks Ray for the reply. Now I understand that it's set up for a reason

Hi all, When viewing the data in Oracle connector stage, it displays only a part of the result set and "fecth more rows" retrieves the next set of records in the resultset and so on. Wondering whether there is any setting that will display all records together without having the need to do...

hi all, I had a workaround. I used the Fix function with precision 5 to round off to 5 positions. This reduced the number of discrepancies with the values significantly as comapred to output by server job which uses a Double data type. Could anyone who converted a server job to parallel face such an...

Hi, I am converting a server job into a parallel job. The server job has a column which is defined as Double with length 25. the target is Oracle table where the corresponding data type is Varchar 25. When I used the same data type definition in parallel job, I was getting the value for some records...

Thanks Ray. I don't have a Premium membership currently. I may take it in the future. May I request to please add the missing parts of the reply. Thanks.

I am trying to rewrite a server job to parallel job for performance improvement. Currently the server job calls 3 server routines. I have 2 options here. 1. Create Parallel routines and call them in the Parallel transformer 2. Use a BASIC transformer and continue to use the server routines. In this ...

Hi all, I have a scenario to implement in a parallel job using Oracle connector stage. Basically, based on the business logic, I will have to generate a SELECT query with a where clause and Oracle connector stage execute that. Since I would need to execute multiple queries and the output columns are...

Looks like the WHERE caluse would be added/modified only if Partitioned read is enabled. The Gurus here can confirm this. I could see the following from Infosphere Information Server documentation at http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=/com.ibm.swg.im.iis.conn.orac...

I am using 'Continue' for lookup failure in lookup stage. I am expecting multiple records matching lookup. Currently in the server job,using DRS stage the select query is like select col-list from tab1, tab2,...tabn where tab1.col1=? and tab1.col2 is not null and rowid=1 In this case, always the fir...

I am using Auto partitioning in the job.

Thanks for your replies. The existing job is written in server and uses DRS stage for lookup. in DRS stage, where clause is getting included in the SQL and lookup is working as expected since there will be only one value to be matched with key column value. Since I am unable to have this same logic ...

This is a normal lookup and I am using Oracle connector stage to feed data to the lookup stage

Thanks for the reply. Sorry, I am missing something here. My design is like this. sequential file . . Transformer stage . . Oracle connector stage .... Lookup stage . . sequential file What I am doing in the job is like this. I have defined Oracle connector stage and loaded the column definition by ...

We have a server job that uses 5 look ups (joining multiple tables in the SQL query, many of the tables used in queries are huge with many hundred thousand records) and we have noticed severe performance degradation. I created a parallel job and used Oracle Connector stage for the look up. Since in ...

Hi all, I have rewritten a server job with a parallel job for better performance aspects. This job basically reads a sequential file and performs 5 different lookups and write the resultant data into another sequential file. I am using Oracle connector stages for lookups as against DRS stages in Ser...