tmap : need 10 lookups and the table for the lookup is always the same: need simplification

[android1686764069]

Hello

I have this job:

My question is about the lookup tables. They query is the same for all of them. I need to an inner join which is done with tmap.

Can I have only one lookup table but 3 lookup rows which connect to the tmap?

I try woth treplicate but I can connect one row only.

In my real job, I have 10 lookup tables, And i'd like to avoir to copy 10 times my lookup table because it is the same each time

[Anonymous]

Hello,

If we understand your requirement very well, you are able to store this same query value in a global variable using tSetGlobalVar. Name it " query" or whatever. Then you can use this global variable in your tMap via ((Integer)globalMap.get("query"))

Feel free to let us know if it helps for you.

Best regards

Sabrina

[ThWabi]

Hello,

an idea might be to use one DBInput component to write your lookup query result into a tHashOutput component. You would then still need 10 tHashInput components for the lookups (I am not sure if you can avoid that), but you have only one DB component to configure (e.g. if connection information changes).

Best regards,

Thomas

[android1686764069]

ok, thank you