I am having a hard time understand what this mapping logic is talking about and what i need to do to implement it in tmap.
I am being asked to use the thiveinput and tmap componenets to first select the fields and then implement mapping logic in the tmap component. Any help would be greatly appreciated.
@idontknowany ,for all the fields it is same logic,in tmap ,in the output section enable expression filter and write below way.
row1.event_id.equlas("row2.event_id) && row1.event_activity_type_cd.equals("update_adress_phone_number")
I do not know Hive, but I understand your screenshot as having two files/tables ('agreement' and 'event') with certain columns (attributes).
These tables are joined on 'event_id' and activity_type must have a given value. So here is a suggestion of how to implement that in tMap:
Ajust the output columns and tMap join settings to your needs.
You could use expression editor in the output side of tmap else, you could also mention it in the query itself in order to get the desired result set!
Join us live for a sneak peek!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.