We currently have a catalog that has had tables added to it from 3 different databases. Although these databases are identical, they have different names.
When adding tables in the catalog there is now only 1 database on the left hand side but the left hand side (catalog tables) is still showing 3 different databases where tables have been added from. I need to get all these catalog tables to be under the same database name. I can rename the Catalog databases, but they still have to be 3 different names. Is there any way (apart from removing all the tables and joins from 2 databases and adding them back into 1 database) that I can get all the catalog tables to sit under just 1 database name? I know I can "Qualify Less" the databases but I still need only 1 catalog database on the right hand side.
Thanks.
When adding tables in the catalog there is now only 1 database on the left hand side but the left hand side (catalog tables) is still showing 3 different databases where tables have been added from. I need to get all these catalog tables to be under the same database name. I can rename the Catalog databases, but they still have to be 3 different names. Is there any way (apart from removing all the tables and joins from 2 databases and adding them back into 1 database) that I can get all the catalog tables to sit under just 1 database name? I know I can "Qualify Less" the databases but I still need only 1 catalog database on the right hand side.
Thanks.