DSXchange

We have a parameter set in that we can pass the values for partition and nodes. The maximum no. of nodes allowed is 3 . So I kept 3 for the noces and in the number of partitions I increased to 7. so the job was running on 21 partitions and hence finished in 5 minutes

hi Thanks for the reply . I tried to increase the number of partitions and nodes . I am running now with 3 nodes and 7 partitions and my job is finishing in 5 minutes.

Thanks for your reply. But my select query already had this CLOB column in last position. And I have kept the datatype as LongVarChar. Do you have any other suggestions as to what values to set for array size, record count, buffer size etc? Or please let me know if I could use some other stage to pe...

Hi , I am trying to read 4 columns from Oracle database using a SELECT query in Oracle connector. One of the columns has CLOB data type in the Oracle database. The query has a WHERE clause to fetch data for a single day. If I run the query in SQL Developer it finishes in 90 sec for 70,000 records. W...