How to Map Multivalued Tuple field in Syndicator for text format ?

[Former Member]

Can any one help me to know about how to map multivalued tuple text file in SAP MDM Syndicator?

[Former Member · Accepted solution]

Ok Ravi thanks...

Splilt multivalued field in syndicator when it will get enabled ? I want to try this option but it was in disabled state

[Former Member · Accepted solution]

Hi Keerthi,

This configuration is available for fields which have multiple values(multi-values) and it is required to break them into multiple fields for mapping to destination.

Please look at the attachment below.

Thanks,

Ravi

[Former Member · Accepted solution]

Hello Ravi

I am having another doubt will this option enable for tuple(multi-valued)?I tried with tuple but it was in disable state

Regards,

Keerthi

[Former Member · Accepted solution]

Hi Keerthi,

No this is not available with Tuple.

Thanks,

Ravi

[Former Member · Accepted solution]

Ok thanks

[Former Member]

Thanks Kwanele

[Former Member]

Hello Ravi,

Can you please confirm,

We can't syndicate a single record for tuple-multivalued it will syndicate multiple records.If i want it in single record means then i need to go with XML right?

Regards,

Keerthi.

[Former Member]

HI Keerthi,

Yes with entire tuple data would do and tuple level filtering is not available.

You can filter data in PI based on required logic.

Thanks,
Ravi

[Former Member]

Hello Ravi

We planned to go with ETL not PI

Regards,

Keerthi.

[Former Member]

Hi Keerthi,

That should not be a problem.Its a basic transformation for ETL.

Thanks,

Ravi

[Former Member]

Hi Keerthi,

There's no option to export single record where by a record have more than one value in a tuple or QT Table. you will need to play aorund with your access or excel.

Regards,

kwanele Nkuna

[Former Member]

I am also having another doubt how to import multi valued tuple data using single source file?

[Former Member]

Hi Keerthi,

All this is because target file cannot hold repeating segments.

Since it is a flat file it will have a multiplying effect in number of records.

e.g If a Vendor is present in 3 Purchase Orgs then number of records in Flat file will be 3*1 = 3 records.

Suppose you connect the same file using Import Manager,then -

For main table there will be only one record as Vendor id is the primary key and every record has the same value.

For Purchase org Tuple - Purchase Org can be Primary Key for "Set Tuple Update Option" and it will hold 3 entries if you create new.

I would suggest,running a complete cycle to get the complete picture.

Thanks,

Ravi

[Former Member]

Ya tried that but i don't want records to be repeated.I want multi valued tuple data to be updated in single record is there any possibility?

[Former Member]

Hi Keerthi,

It would be one to one mapping,meaning there would be 2 records created in text file for 2 values in tuple.Both the values will have same remote key/primary key but different tuple primary key value.

Thanks,

Ravi