MDM Syndication from Multiple Tables

[Former Member]

Can you pull data from multiple tables in one repository and syndicate out to one XML file ? When i do syndication and set up the map, I am only able to use one table - can data be pulled from multiple tables and sent out to one output file - like if we have a country and a city table - can I get one xml file that has all countries and cities in it ? or does each have to be in a separate file.

[Former Member · Accepted solution]

Hi,

Your Syndicator map is built based based on a single source table. So, to answer your question, you can only syndicate one table's data at a time. BUT, if your tables are linked to each other, you will see the fields from the other table also as part of your source hierachy.

Example:

Country Table: Country Code, Country Name

City Table: City Name, Country Code (this field is a lookup to "Country" table).

In the above scenario, if you are building a syndicator map for a "City" table, you can always map both "Country Code" and "Country Name" as your Country table is linked to "City" table.

Hope this helps,

Rajani