I am new to MDM and i am struggling with how to proceed with the below scenario
I have a main product table(Shown below) with COO as a lookup field.I want to import this import this information into the repository.
Given product table with data to be importedProduct Product description
Since MDM uses parametric inport, I want to store the distinct values of the COO in a lookup table as shown below.
When performing data import using the import manager, I first have to fill the lookup table.
Then I have to import the values in the main table ?
If this is the case, how can I link the COO already stored in the look up tables to the products in the main table?