All Forums Analytics
Kanchan 1 post Joined 07/12
25 Jul 2012
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

You must sign in to leave a comment.