1.

Describe what is schema mapping?

Answer»

Schema mapping is accomplished when the physical schema within the TARGET SYSTEM is not identical to the physical schema in the source system. Assuming we are transferring components from DEV (DEVELOPMENT System) to PROD (Production System). The tables in Development System live in DEV_SCHEMA and the EXACT tables reside in the PROD system in the PROD_SCHEMA schema. If an attribute view is moved from DEV to PROD, it will not function as the schema name is described in the definition of attribute view. For the promoted objects to function in PROD, schema mapping ought to be set up in the target system. In this situation, the schema mapping to be designed is:

  • Authoring Schema
  • Physical Schema
  • DEV_SCHEMA
  • PROD_SCHEMA


Discussion

No Comment Found

Related InterviewSolutions