multiple columns that lookup to one single column

SR2210 — Sat, 16 Nov 2024 00:25:09 GMT

Hi,

I would like to get your ideas on my job here. Currently I have one PostgreSQL table (table A) as source table and i need to lookup in another table (table B) to do an inner join. My issue here is I have multiple columns that lookup to one single column.

Table A columns:

col_fullname
col_nickname
col_name

Table B columns:

col_id
col_entity_name

so basically I need to lookup col_fullname,col_nickname, col_name from table A in col_entity_name from table B to get the id and load the id respectively in destination table that has columns fullname_id, nickname_id and name_id

Currently in my job i add two tDBinput components to lookup col_fullname and col_nickname. This is how i lookup the columns respectively in tMap

is there any way that I can do this without having to add multiple lookup table components? because in future i may need to lookup more columns so I'm not sure whether is it possible to only have 1 lookup table component and do all the lookups in the same component.

Please let me know if there are anything that's not clear. Thank you in advance 🙂

Re: multiple columns that lookup to one single column

Anonymous — Thu, 18 Mar 2021 09:21:59 GMT

It is impossible to do several lookup on the same table, it means the join has multiple conditions. For the same lookup table, you can load the data only one time into memory using tHashOutput, read the data using tHashInput when it is used.

Regards

Shong

topic multiple columns that lookup to one single column in Talend Studio

multiple columns that lookup to one single column

Re: multiple columns that lookup to one single column