Matching 2 calculated values against a table.

[JayQueue]

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

[Anonymous]

Hi

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

[JayQueue]

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?