Skip to Content
avatar image
Former Member

Validation/Transformation Question ....

We need to use the abbreviations in the Name field in the Vendor master. The incoming data may be with full name but the business requirement is to use the abbreviations for example :-

INCORPORATED must be INC

ORGANIZATION must be ORG

MANUFACTURING must be MFG

HOSPITAL must be HOSP

The above are some of the examples. The requirement is to replace the full name with abbreviations where ever that is present.

How do we handle this in MDM. I noticed in the data manager there is a tab called transformation where we can specify the Table field name then the Old value and new value but donu2019t know how to execute it. Is Data Manager is the place to handle this?.

Anybody help me with this?.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 12, 2008 at 04:58 AM

    Hi JP,

    Yes,you are right.Datamanager is responsible to do transfomations.As you said we have to

    specify the field name on which you want to create the transformation and also specify

    the value to be replaced in From field and new value in the To field.

    Suppose for example

    Specify INCORPORATED in from field and INC in To field, then INCORPORATED is replaced

    with INC.if you don't specify anything in To field, it just simply deletes the specified value

    available in from field.

    Token option is also availble to replace the values tokenwise.

    To get more details go through below link:

    transformation-in-matching-mode-in-data-manager

    Cheers

    Narendra

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 12, 2008 at 06:23 AM

    Hi JP,

    MDM is designed to handle such a requirement through the Transformation tab in MDM Data manger.

    -You can transform any field value to another by appying proper transformation on them in the FROM and TO field.

    - Go to MDM DM and in the transformation tab write the value you wnat to transform in the FROM and the expected result in the TO .

    - If you have n number of such requirement an entry specific to each must be made.

    - eg: FROM (Corporation) TO (CORP)

    NOTE:

    A couple of things to note while applying transformations

    - Transformation are CASE sensitive

    - The check box beside each transformation is to be used only when you want the tokens to be compared.

    eg: Walmart to Mart -(This is my transformation)

    Without checkbox:any name walmart will be transformed to mart

    With Checkbox:Walmart Inc will also get transformed to Mart.

    Hope It Helped

    Kindly Reward Points If Found Useful

    Thanks & Regards

    Simona

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 12, 2008 at 10:53 AM

    Hi,

    As Jitesh Said, I think Transformations alone cannot solve your Purpose. Because as you make transformation, you have to make Rule and then Strategy, Moreover if your Rule contain Transformation having this Field only then all your records will act as Duplicates. Even after running strategy, you could not able to see transformed converted value say INCORPORATED to INC, it happens at the Database Server Level.

    So i would suggest you to go for 4 Assignments. In all four Assignment Select the Table Field Property as field containing these values INCORPORATED

    ORGANIZATION ,MANUFACTURING and HOSPITAL .

    Say Create Ist Assignment name as INCORPORATED TO INC In Assignment Expression write just as INC, then in MDM Data Manager, Go to Free form Search ---> Corresponding to your Field Write INCORPORATED so, now Data Manager filter the records Containing INCORPORATED, Now Run this Assignment INCORPORATED TO INC your field containing all values get Converted to INC, Similarly you can do for ORGANIZATION ,MANUFACTURING and HOSPITAL .

    Hope it will Help you,

    Rewards if Useful......

    Mandeep Saini

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 12, 2008 at 12:27 AM

    Hi JP,

    Please refer this link

    Validation/Transformation Question ....

    If you want to change the value from Incorporated to Inc .Use assignments . By using Transformations you can easily identify the duplicates .By using transformations you cannot change the original records.You will be able to see the Transformed value in preview tab.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 12, 2008 at 06:11 AM

    Hi,

    Transformation tab will not serve your purpose. It is used in Matching mode only. It works like say you have two records containing HOSPITAL and HOSP as the values for the fields but both means the same so we can create the Transformation that transform HOSPITAL as HOSP and identify the duplicates i.e. both HOSPITAL and HOSP are same.

    You have to handle your requirement in Import Manager. In value mapping you can write the Destination or Converted value in front of all HOSPITAL, MANUFACTURING etc.

    Regards,

    Jitesh Talreja

    Add comment
    10|10000 characters needed characters exceeded