topic Re: Matching 2 calculated values against a table. in Talend Studio

Matching 2 calculated values against a table.

JayQueue — Fri, 15 Nov 2024 23:33:12 GMT

Hi,

Problem:

I'm calculating 2 numbers in a tJavaRow: rrnr19 and rrnr20.

I want to test both numbers both numbers against a databasetable.

Now I have this setup as a test

I have a rrnr19 flow and a rrnr20 flow that each has its own tMap for lookup against a database.

Is this the way to go or can it be made more efficient?

-Jonathan

Re: Matching 2 calculated values against a table.

Anonymous — Fri, 05 Nov 2021 06:44:15 GMT

I would like to load the data from DB table one time and store them into memory using tHashOutput, use a tHashInput to read the data from memory whenever you want to use in next subjobs.

Regards

Shong

Re: Matching 2 calculated values against a table.

JayQueue — Fri, 05 Nov 2021 08:53:15 GMT

Great tip, thank you!

And thinking of making the lookup in a different job and make it run with parameters rrnr19 and rrnnr20. But would make this process a bit slower?