Hello,
I am trying to implement the following SELECT statement in TOS 2.2.4:
SELECT 2_mil.id_key,
mi.col_1,
mi.col_2,
mi. col_3
FROM 8_million_records 8_mil,
2_million_records 2_mil,
500_records me,
tmp_file_data mi
WHERE 8_mil.id_key_alt = mi.SecurityId
AND 8_mil.id_typ_alt_key = 'I'
AND 8_mil.id_key = 2_mil.id_key
AND me.id_ctry_std IN ('A', 'B', 'C', 'D', 'E'),
AND me.id_exchangekey = 2_mil.id_exch_pr
AND 2_mil.id_replaced = 'N'
AND 2_mil.id_del_grd = '0'
AND me.id_del_grd = '0'
When I tried to join all tables in one tMap I never received a result, so I separated the SELECT on several sub joins. Can you please confirm that this is the right way to implement this SELECT in Talend or probably there is a better option to do it in TOS 2.24 or in TOS 2.3.0?
8_million_records has the following select:
"select id_key, rtrim(ltrim(id_key_alt)) id_key_alt from 8_million_records where id_typ_key_mil = 'I'"
2_million_records:
"select id_key, id_exch_pr from 2_million_records where id_replaced = 'N' and id_del_grd = '0'"
500 records:
"select id_exchangekey from 500_records where id_ctry_std IN ('A', 'B', 'C', 'D', 'E') and id_del_grd = '0'"
