Skip to Content
avatar image
Former Member

Two Simple fields in to tuple

Hello MDM gurus,

We need to move data from old mdm repository to new repsoitory data model with multi valued tuple. we have number of cases that old repository have simple fields that we need to combine to form multi valued tuple. we need to map all this simple fields to tuple..so that tuple would hold multiple record while syndication. is there any way we can achieve this combining fields to map it to single field.

Here is one scenario.

In old repository

phonetype

phonenumber

in new repository

Tuple

phonetype

phone number

Second scenario

-


In old repository

type_field1

type_field2

in new repository

Tuole

type

field ( both field1 and field2 have to be added here and dynamically we should have type added here in first field "type" according to the field added )

Please help me resolving this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 01, 2011 at 12:30 PM

    We need to move data from old mdm repository to new repsoitory data model with multi valued tuple. we have number of cases that old repository have simple fields that we need to combine to form multi valued tuple. we need to map all this simple fields to tuple..so that tuple would hold multiple record while syndication. is there any way we can achieve this combining fields to map it to single field.

    Here is one scenario.

    In old repository

    phonetype

    phonenumber

    in new repository

    Tuple

    phonetype

    phone number

    For this scenario I assume it is Phonetype which changes and as per that Phone number changes

    So for One Main Table entry you can have multiple entries inside Tuple.

    So first syndicate out all the records from Old repository.

    You will have multiple line items for simple fields,which is avoided if you have a repeating element like Tuple,Qualified table.

    So map main table primary key and map these fields with Tuple fields and set tuple update as Phonetype or other matching fields.Import the data.

    Second scenario

    In old repository

    type_field1

    type_field2

    in new repository

    Tuole

    type

    field ( both field1 and field2 have to be added here and dynamically we should have type added here in first field "type" according to the field added )

    In the same way as explained aboove you can import the data.Just confirm that if you are having repeatable elements in main table that will create multiple line of entries,which can be avoided if you have a Tuple.

    So your syndicated data should be in that fashion.

    Thanks,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 01, 2011 at 09:34 AM

    the easiest way to do this is to export the data out of ur old repo

    and then create new repo with tuple fields and then import data (just exported file) by mapping field 1 to tuple -> field1 and field2 to tuple->field2

    the 2nd scenario is not clear to me - clarify !

    thanks

    -Adrivit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 07, 2011 at 04:07 PM

    Answered

    Add comment
    10|10000 characters needed characters exceeded