DSXchange

View the data from DB2 stage, check what date it will show. Then you u will come to know that where is the error, check also any warning in the job after running.

This is regarding DB2 Connector stage, not able to see the auto generated SQL query within the DB2 connector stage.

Rgds
Mahantesh

Do some RND

Take single source and load to the Single target table, check the same in both the enviroment (sit and dev)

Source table ---------> Target table1

Rgds
Mahantesh

Hi Dsxians, We are facing one strange issue in Ds Parallel 7.5, related to dataset. In one of our job, its a simple job extracting the data from DB2 API stage and loading into a dataset. With the first run, we got the warning When deleting data set PROD_DS, previous delete attempt not complete; rem...

Hi, I'm converting a server job into parallel. In server user status will be given like outputroutine(value) in one job, and that value will be ued in another job. i.e., I need a user value from the previous job. how should i get it in parallel job sequence. should i create a output routine U can u...

If data is huge u have to go for external sort stage because it uses temp. space (scrach disk) for sorting the data. regards mahantesh Hi, In my jobs there many joins and lookups.I want sort the main and reference data . For main link the no. of records varies from 200000 to 60000000 for each join. ...