Value Conversion and Mapping Issue.

[Former Member]

The context is we have to load Main table along with Flat LookUp table (this table has 4 DF) data.

Step 1. We have to map Display fields of Lookup table first and those are Col1, Col2 (LookUp), Col3 (LookUp) and Col4(LookUp).

Step 2. We have to make sure the value mapping is performed for 3 DF (due to 3 LookUp fields).

Step 2. We have to combine all four display fields and do the map with Field LookUp1 <Col1;Col2; Col3; Col4> of Main table in Repository.

Step 3. We have to perform the value mapping of these combined DF's. - This is not working because the data on the Source Value mapping is (NULL; [NULL,Col2]; [NULL,Col3], [XYZ, 11001]) and the Destination value mapping is (NULL; [ZERO,Col2]; [ZERO,Col3]; [XYZ, 11001]).

Dont know why NULL has been displayed as ZERO on the Destination Values Mapping side and i did checked in DataManager the data remains NULL only and there is no ZERO.

[Former Member]

Hi Hemanand,

The destination side values reflects the lookup values you have imported in to the MDM rep from the source.

It will hold the values present in the source file that you have imported using the import manager.

If you have imported Null(Blank) values then blank values will come in.

Just check out the Data type that you have assigned to that lookup display field. If it is Integer field then could be thats the reason for the 0 value coming.

Try making it as Text and see the result as Text data type is capable of importing even numeric values in MDM.

Also if your source is of the excel type check the data type of the fields in excel too using the menu bar.

Hope it helped

Thanks & Regards

Simona Pinto