topic Re: Configuration of tMap for batch processing in Talend Studio

Configuration of tMap for batch processing

HeinrichL — Mon, 30 Aug 2021 10:07:52 GMT

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

Re: Configuration of tMap for batch processing

Anonymous — Tue, 31 Aug 2021 03:21:51 GMT

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

Re: Configuration of tMap for batch processing

HeinrichL — Tue, 31 Aug 2021 05:42:03 GMT

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