topic tMap reuse 1 Lookup in same tMap in Talend Studio

tMap reuse 1 Lookup in same tMap

mobmsc2 — Wed, 06 Dec 2017 13:13:06 GMT

Hi Talend Users,

Is it possible to reuse the same lookup source in 1 tMap? I have a number of columns I want to convert using a lookup table. Each column contains the primary key for the lookup table but can I configure 1 tMap to convert all the columns in 1 go or do I need to position the 2 or more tMaps in serial

Most examples I have seen seem to handle the case where you want 2 or more columns as keys to return 1 value from the lookup table

Example input table

ID as int
Product1 as string
Product2 as string

Example Lookup Table

ProductID as string
ProductPrice as int

Desired Output Table

ID as int
Product1 as string
Product1Price as int
Product2 as string
Product2Price as int

Re: tMap reuse 1 Lookup in same tMap

TRF — Wed, 06 Dec 2017 15:12:56 GMT

Hi,

Case not clear in my opinion.

However, you have as many lookups as you want for the same tMap, limit is the lisibility.

Re: tMap reuse 1 Lookup in same tMap

mobmsc2 — Wed, 06 Dec 2017 15:23:19 GMT

If i have 2 lookup inputs to the same lookup file is there a danger of file locks or other issues when running the job?

Re: tMap reuse 1 Lookup in same tMap

TRF — Wed, 06 Dec 2017 16:24:10 GMT

No, as files are for input only.

Re: tMap reuse 1 Lookup in same tMap

mobmsc2 — Mon, 14 May 2018 11:46:55 GMT

Coming back to this could I use a tReplicate to generate multiple lookup flows for the same tMap from 1 source or does the tMap only accept 1 flow from the same component?