Change Table Names in Universe to a Fully Qualified Table Name

[Former Member]

We have implement the HR Rapid Datamart. The table names just have the table. We need programmically to have the table use a fully qualified name. Example Company table needs to read the schema.table name DM.Company. Is there a way to set it in the Custom Parameters section of the Edit connection window to automatically add the schema name to the table name programmically without having to rename the table names in the universe?

[Former Member]

Actually I was able to do it by adding the following command "set schema <schema name>" to the ConnectInit parameter in the Custom Parameters window when you edit the connection.

[former_member142702]

This is a neat workaround but I guess that this is vendor specific.

Regards,

Stratos

[former_member142702]

You can add the schema name for all tables in one pass if you select all of them (press the CTRL key while selecting them) and them go to the properties window and type in the schema name in the owner field.

Regards,

Stratos