Partial match for Value Mapping in Import Manager

[Former Member]

Hello Experts,

We have a import map which is used to do mass insert of data into the main table. This is done as & when required by the end user.

We have a qualified lookup field which has a flat lookup filed as the Non-Qualifier. This flat lookup field is refering to a Lookup Flat table, which has mulitple dispay fields like Code,Name, Status etc. (14 fields in total) where as only the Code is the unique field.

We have only the unique field in our source file which we use for the import. Since we have only a part of the display fields in the source, the automap functionality in the Value maping section doesn't work. It becomes very tedious for the user to manually map all the values for this field.

Is there any way by which we can convert the source or target values in the import map, so that we can map the values using the Automap feature?

Your help & suggestion for alternate approach is highly appreciated.

Thanks in advance.

Regards,

Uday

P.S. We are using SAP MDM 5.5 SP6.

[former_member205403 · Accepted solution]

To convert source values, Try conversion filter.. also you can concatenate source values using partition fields feature of import manager.

Regards,

Shiv

[Former Member]

Hi Shiv,

None of the conversion filters will be useful here. Could you please elaborate on the partition fields part. By the way, we are not using any hierarchies or taxonomies. My source field has to be mapped to a Non-Qualifier field in a lookup qualified table associated with the mail table. This Non-qualifier field is in turn connected to a Lookup flat table with 14 fields constituting the display fields, of which only the first is the unique field. My source field has only this unique field value.

Hi Vinay,

Could you please elaborate on "refresh remote keys for each record in flat table with unique value". Also do i need to enable key mapping for my qualified table as well?

Thanks in advance.

Regards,

Uday

[former_member189669]

Hi Uday,

No need to enable remote key mapping for QLT. Please execute the below steps(stated with an example) -

1. Among all the fields in the referenced lookup table, identify the lookup fields and the tables they are looking up .

For eg.If you have a lookup field as 'Country' as one of the fields, look up table will be 'Countries'

2.For the identified lookup tables, set 'key mapping =Yes' in Console.

For eg, For Country Lookup table ,set Key mapping to 'Yes'

3.Import values into Lookup table (Import manager)/ Remote key update -

In import manager, select source (local file) and destination as Countries flat table.This Table will be haing 2fields - Code and description.Clone the 'Code'field and map it to Remote key field in destination hierarchy.Map code and description to equivalent destination fields. Select 'Code' as matching field > Perform import into lookup table.

Check if the records in countries table are updated with remote keys(in Data manager> right click on a record> select 'Edit key mappings' > view key mapping for the record)

3.Import to Qualified table/Auto value mapping -

Now, in the import map for qualified import , map the source field and destination field (of lookup type), all the values of this field will automatically map.

Similarly, refresh remote keys mappings for all the lookup tables first and then you can see auto mappings of values happening for the lookup fields.

Regards,

Vinay M.S

[former_member189669]

Hi Udya,

You can achieve auto-value conversion by enabling remote keys at the lookup table level. And, refresh remote keys for each record in flat table with unique value.

Value mapping - When a Source Field is mapped to a Destination Field that has key mapping enabled, the MDM

Import Manager loads value mapping from the table of remote keys rather than from the map, automatically mapping each Source Value to a Destination Value if the source/destination value pair exists in the key mapping .

Regards,

Vinay M.S

[Former Member]

Hi,

You need to use remote key concept here.

Make clone of unique field(In your case code) on source side and map it to the remote key on destination side in the look up table

map and import it.

So whenever you do import for main table, the code which is coming from source automatically mapped to destination records

based on remote key.

Thanks,

Narendra

Edited by: Mullapudi Narendra on Dec 15, 2009 7:19 PM