Teradata Database Name change in BO Universe

Analytics

Teradata Database Name change in BO Universe

Hi ,

We are developing a universe that contains tables on Teradata. There are 3 environments, development, test and production. Teradata database is on a single machine where the tables for 3 environments can be identified by their database prefixes. For example calendar table in 3 environments would be:

DD_HLP.calendar

DT_HLP.calendar

DP_HLP.calendar

Our problem here is when we export the universe from development server to test, the database.tablenames stay the same as in development and need to renamed manually.

Can you please suggest is there any utility throug which we can automaticaly do the same?

Thanks in Advance!

Kanchan