Data Lookup element in Data Movement Model
I'm new to PowerDesigner and I cannot quite understand how the Data Lookup Element in Data Movement Models works.
Let's say I have two tables PERSON_TABLE ( Person_Name, Country_ID) and LOOKUP_TABLE(Country_ID, Country Name).
I want to lookup Country name in the lookup_table.
I would expect that I have these two tables as and input to Data Lookup.
I don't get how do I set in Data Lookup that the key value in lookup_table is country_id and that it should be joined with country_id from person_table and country_name should be passed further.
Thanks and best regards,