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!
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Pick up some tips and tricks with Context Variables