Two Simple fields in to tuple

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member]

Answered

[Former Member]

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