The mapping between authoring and physical schema's is stored in the configuration table "_SYS_BI"."M_SCHEMA_MAPPING".

Related questions