Configuration of tMap for batch processing

[HeinrichL]

Hello everyone,

I have a large lookup table and searched for a good solution. I've found this example in Talend help: https://help.talend.com/r/en-US/7.3/data-integration-job-examples/batch-processing-large-lookup-tables

I have a tOracleRow with the query: select 'MAX_ID' as Key, max(id) as value from mydb;

I also have the 3 necessary context variables Recnum(int), Batchrec(int), MAX_ID(String) and the tContextLoad component.

What do I have to do in the tMap/tContextLoad component in order to perform the job like in the example above.

Thanks for your time and help!

Lisa

[Anonymous]

Hello,

tXXXRow component is usually used to any type of sql statement excepts select statement, we use txxxInput component to execute a select statement.

Could you please try to modify your component and use a tOracleInput with the query: select 'MAX_ID' as Key, max(id) as value from mydb; ?

Best regards

Sabrina

[HeinrichL]

Thanks for your Advice! I changed it to an tXXXInput. Whats is the next step and why do they use the tMap component in this example?

I've never used tContextLoad before.

After trying some things my next question would be what does this tJava component do next to the tLoop ? This also isn't mentioned in the example in Talend Help.

Best Lisa