Caché Monitor helps by query tables in different namespaces.
With the features mapped tables and federated namespace Caché Monitor support the request of writing SQL query across namespaces with the idea of a federated namespace.
I got quite some people asking for an option to query some tables from different namespaces on a sql statement. Rather than doing some obscure SQL pre-parsing trickery, Caché Monitor introduce a way of mapping tables from different namespaces into a new virtual/federated namespace, a unified namespace, lets call it a federated namespace.
How does this work? Caché Monitor creates copies of the meta data in the federated namespace and use the Extended Global Reference to map the original data into the new Namespace.
All this is done automatically!
Read here how to use it: Combine tables across namespaces in a SQL Query – Part 2