DSXchange

If I have a link sort done on the left link of the join then I get the error.
The input comes from the transformer stage I checked to clear partitioning in the output link yet I get the error...
Ash could u help me here.

Thanks for the reply...

kill -9 PID

Use the above command. But please don't kill any process as mentioned to you earlier. This was for FYI.

I have observed that in most of my parallel jobs which uses a sort stage I get this kind of warning mentioned below. Could any one please elobrate and tell me why I get this warning. Here in this sort stage 'Sort_Brck_Mrtr_Str_I' has the partitioning done on the column BRCK_MRTR_STR_I. I perform a h...

I have observed that in most of my parallel jobs whihc uses a sort stage gets this kind of warning. Could any one please elobrate and tell me why I get this error. Here in this sort stage 'Sort_Brck_Mrtr_Str_I' has the partitioning done on the column BRCK_MRTR_STR_I. I perform a hash partitioning on...

Any solutions?

[quote="ray.wurlod"]What are the data types of the columns mentioned in the WHERE clause? Check the first entry for the job in the job log, to determine the values that were passed for the parameters. ...[/quote] The datatype of PULL_BTCH_CRTE_D is date and the job parameters passed has th...

I am trying to delete just two rows from a DB2 table which as to meet a criteria of a date range. The first stage is a row generator which generates 0 rows to initiate the job the next stage is the DB2 stage which deletes the records DELETE FROM #$PL_SCHEMA_NAME#.DLY_PULL_AGG WHERE PULL_BTCH_CRTE_D ...

[quote="keshav0307"]use user defined sparse query, and and have reject link for the lookup not found..[/quote]

Thanks Keshav.
Was able to write the user-defined query and work appropriately.

[quote="ray.wurlod"]You can check the condition in the "rules" part of the Lookup stage. If the lookup fails there are four possibilities; Continue, Drop, Fail or Reject. If the condition to undertake the lookup in the ...[/quote] Thank you for the reply. Here the issue is with c...

[quote="keshav0307"]if you use sparse lookup, it can be done in a single lookup stage.[/quote]

Could you elobrate... how is it possible? If you use a sparse lookup how will I check the condition as we would not be able to use constraint.

Consider a scenerio, where I have to perform lookup on a reference table STROE based on a column say STORE_I and also check for the condition where BTCH_CRTE_TS is between ETL_PRCS_EFF_TS and ETL_PRCS_END_TS. ETL_PRCS_EFF_TS and ETL_PRCS_END_TS are obtained from the reference table and BTCH_CRTE_TS ...

Hello Ray,
I am not able to view the complete answer you mentioned.

In Write method options we have one option as 'Load' and other as 'Write' wanted to know the difference between them.

I wanted to use the Load option and would like to know the impact on the restartability logic applied in the job.

We have huge volume of data to be loaded to a target DB2 table approx to 11 million records daily and also have to take care of restartability if the job fails. We have only inserts to be done on the target DB2 table. We plan to go for a bulk load option in DB2 for loading the huge volume of data. W...