Schema Name Change (OwnerName) in Universe on top of Teradata

[Former Member]

Hi ALL,

I am trying to search a solution for an approach with universe designer on Teradata DB.

We are supporting a universe which is created on top of Teradata DB, now the requirement is to move this universe from Teradata PROD DB to Teradata PreProd DB.

The Challenge I am facing is:-

1) The DB name (schema name) for both the Teradata Prod & Pre-Prod is different e.g. PRODDB & PREPRODDB

2) The table/alias/objects in my universe are having name like DatabaseName.TableName.ColumName

3) If I change the parameter <Parameter Name = "Owner">Y</Parameter> to "N", it will only reflect for new tables, existing tables are not getting updated.

The  problem is that in case of TD, the connection goes to server not to a specific database like in case of Oracle. If we don't have schema name in front of the table it becomes harder to browse for a new table in the table browser.

Does anyone has any solution on how to handle this problem?

The basic idea on how to move from one schema to another.

Cheers,

Vivek Chauhan

[Former Member]

Below steps might be helpful

1.Selecting multiple tables at once

2.Right click on one of the table

3.Rename Owner/Qualifier from "PRODDB" to "PREPRODDB". All the SELECTED Tables will be updated at once.

4. Perform "Integrity Check" after changing universe connection as well.

-Thanks,

  DEEPU