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:
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?