Can we use Tables as cross client

[Former Member]

Hi,

Can anyone plz explain that "Is it possible to use structure of tables of one repository into another repository.

I mean can we reuse them"

if it is possible .... how ?

thanks

guna

[Former Member]

Hi Sekhar,

If you got the required information, kindly update the thread status which would be helpful for other people looking for similar kind of information

Regards,

Jitesh Talreja

[Former Member]

Hi Sekhar,

There is no link available between the MDM repositories. However with the help of Export/Import Repository Schema commands you can transfer the structure of tables from one MDM repository to another without affecting the existing structure or data of destination repository.

1. Export the repository schema containing desired tables. This will create the Schema Migration File.

2. Unload the target repository

3. Right click on repository and select Import Repository Schema. This will ask for .xml file

4. On Selection of XML, it will display the entire structure of the first repository, now you can select add for the tables you want in target repository.

Note: For all other tables and fields, select the action accordingly else it will try to match both the structures and will update the existing repository.

[Former Member]

Hi Guna,

If I have understood your question correctly, you want to know whether we can create a repository and then use its structure in any other repository and make it as a re-usability.

This is not possible for 2 repositories as 2 repositories do not talk to each other in MDM. They are 2 different entities. However it is only possible from with in a repository if you want to re-use the Tables.

For this purpose, you can have the look-up tbales created and then from different tables you can use link/refer to the look-up table.

For ex, a table like country, may be created as a look-up flat table and from the Main table, you can have a field pointing to Country table. From Main table you can use the Country table.

Also, you can have another Look-up qualifier/ flat table using the same country table created earlier. This will help you improve the performance as you will be creating the Country table once and will be re-using it any number of times required just by linking it with other tables.

Hope it helps.

Thanks and Regards

Nitin jain