Thread: Logical Column Mappings update

If I want all my Logical Columns in the Business Model layer to point to a new and different database (e.g: EIMDW) instead of "ORAEIMU", what is the quickest and easiest way to update all the column mappings at once in the Business Model Layer? Your feedback will be very much appreciated Boniface Ntawutarama

Hello Maybe someone else has a better suggestion. But as for our project's case, when we want to point to a different database with EXACT same definition of schema, tables, and fields, we simply re-define the ODBC connection to point to a different Data Source Name (in System DSN) or we edit the actual data source definition in tnsnames.ora. This would mainly affect your physical layer, though, not just your BMM. If you wish to use both...