tDBInput - cursor size 100000 - get the error record id

Anonymous — Tue, 27 Nov 2018 19:22:42 GMT

Hi,

I have a job that has tDBInput ---> tJavaFlex----> tDataShuffle ----> tDBOutput

In tDBInput the records are read with cursor size - 100000 followed by shuffle.

I am using tJavaFlex component between reading and shuffling to get the current record id - globalMap.put("currentID", row1.ID); This is used in tDie component to log the id when it failed.

My question is:

Since the fetch is based on cursor and not on individual record, will the value of "currentID" be the last record in the cursor or will it be assigned the current record id that is read from table?

Could you clarify as I am not a DB expert and trying to understand how it would work.

Thanks

topic tDBInput - cursor size 100000 - get the error record id in Talend Studio

tDBInput - cursor size 100000 - get the error record id