on 05-11-2012 6:42 AM
Hi,
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 imported
Product | Product description | COO |
---|---|---|
A | Product A | US |
B | Product B | IN |
C | Product C | IN |
D | Product D | US |
E | Product E | US |
Since MDM uses parametric inport, I want to store the distinct values of the COO in a lookup table as shown below.
Lookup table
COO | COO description |
---|---|
US | United states |
IN | India |
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?
Please help.
Thanks,
Vignesh
Hi Vignesh,
In MDM you must be having main table with fields:
Product which is text
Product Description ( Text)
COO (Lookup Field referncing to Lookup Table )
Now First process you have to load lookup table for that:
Connect the file for lookup table to Import Manager(IM).
In Source select the file and in Destination select Lookup Table.
Go to Field maaping map the fields and Import.
Now to Load Main table product data.
Connect the file with product info with IM.
In source select the file.In Desctination select main table.
Go to field mapping .In destination you will find fields Product,Product Description and COO
Map the source fields to Main table
when you map source field COO to main table field COO which is lookup field ,you will get values enabled in Value Conversion and mapping pane.
Map the values also.
and then import.
Regards,
Neethu Joy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Neethu,
Thanks for your detailed explanation.
Please help me undertand the below also.
After i finish loading the look-up table with COO values and when I proceed with mapping the main table records, do i have to map the value of COO for each product record that I want to import one by one?
If there a lot of product records, this will take time right?
Thanks,
Vignesh
Hi Vignesh
1) suppose you import look-up first , then you are importing main table, then under map fields\value tab-> value conversion and mapping, you have to map value from source to destination, if the the values you are importing is already present then it will be automaticaly got mapped(when u will click auto button), if value is new, you have to add it in destination by "add" button and then map.
2) second way is to use join
Regards
Nitish Sharma
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.