MDM nested lookup Main syndication

[Muniyappan]

Hi,

WE have a main table as City which has City ID(text), Code(text) , Route Driven Hub (Tuple),legacy code(look up main) etc as fields.

Route driven Hub is  tuple with fields like Hub ID, Hub NAme, City(lookup main City) etc.

We have an interface for Route Driven Hub tuple.In XSD we have fields like Hub ID,Name,City ID, City code,Legacy City code etc

We are few fields from City main table but syndicator is not showing all the fields and hence I am not able to map few fields.

I reloaded MDM repository, restarted MDM and DB server but it did not work.

ANy suggestions how this can be resolved?

Regards

Nisha

[Former Member · Accepted solution]

Nisha,

Let me explain, what I understood. You have following repository structure:

Table Name     Field Name            Field Type

City (Main)         City ID                    Text

City (Main)         Code                       Text

City (Main)         Route Driven Hub     Tuple (Hub ID, Hub Name, City, which looks up to City main table)

City (Main)         Legacy code            Lookup Main

Can you let me know the type of the fields, which are not available in Syndicator, also let me know, they are not available in source or destination side in the mapping tab?

Are these fields part of Tuple or any main table?

Thx/ -Tarun

[Muniyappan · Accepted solution]

Hi Tarun,

The fields are not available on source(repository) side.

I am trying to create a map for Route driven Hub tuple.In the map I have to map City ID,City Code, City Legacy Code from Route Driven Hub tuple to destination XSD.

In syndicator I can see City ID, City codebut not legacy code.

It seems like memory issue but not sure what is the issue.

Plz suggest.

Regards

Nisha

[Former Member · Accepted solution]

Nisha,

Would it be possible for you to create a sample Tuple (XYZ) and add the Legacy Code lookup main field into it and then check in Syndicator, if it is available or not?

Thx/ -Tarun