ODI Knowledge Modules often use temporary objects to:
These temporary objects are always stored in a particular schema or directory called the Work Schema (or staging area).
These work schemas should be kept separate from the schema containing the application data (Data Schema).
Example:
On the target data servers, you should almost certainly create a dedicated work schema. This will store:
On “read-only” source data servers the following objects may be created depending on the way you want to address these servers:
The staging area (or Work area) is first define when you create a physical schema but you can change it in the interface properties