DSXchange

I have a job with DB2 connector writing the output to a sequential file. First when I run the job it took almost 7 hours to complete. I have fine tuned the SQL and then re-run the job and it completed in less than 5 minutes. When the same job is run after two days, it is taking almost an hour to com...

Are you using stage variable?

Check if any special character or space is getting padded in any of your inputs.

did you trim your keys before doing the change capture?

Thank you all for your replies. I have tried partitioned the data in the before stage and used same partition on lookup links. But the warning is not getting removed.

In lookup stage, I am using hash partition on key colums on the stream and the reference links and I am getting the below warning in director. When checking operator: Operator of type "APT_LUTCreateOp": will partition despite the preserve-partitioning flag on the data set on input port 0. ...

Thank you all for your replies. At mainframe side the initialization is not done. Convert function is used to convert the low values to spaces.

Is it possible to identify low values in complex flat stage (source stage)?

Hi, In Oracle coonector stage when partition read method is selected as Oracle partiiton then there are no issue, but when the method is rowid range and in the meta data if column name is prefixed by GROUP_* then we are getting the below error message. The OCI function OCIStmtExecute returned status...

Is there any way to identify which job created the dataset by only knowing the dataset name?

could you paste the warning message you are getting in the log and also some sample input and output data?

what is the partition defined on ODBC stage?

All the records in a column has to be combined into a single record using the stage variables in transformer. 1. Create a dummy key column, sort and partition on that column. 2. In transformer use stage variables, one will store the current record and the stage variable will append the records. e.g....

use 2 aggregator stage and then join it back based on the common key.

use an aggregator to get the sum of all profits based on Product and then use this value in the next transformer to get the profit%