Append Schema
Determines if the source Schema is appended to the object name in the staging layer. The default naming convention is to name tables using the Record Source and object name. The AdventureWorksLT Source table SalesLT.Product is normally staged in the AWLT.Product table. For sources with multiple schemas, enable this to distinguish between tables. For the product table the new staging table name would be AWLT.SalesLT_Product.
When enabled, the source object's schema is combined into the staged object name (for Staging, External, Persistent Staging Area and delete-detection objects), positioned according to the Suffix Or Prefix Object setting.
When to Change This Setting
Keep the default N for sources where object names are unique within the connection. Enable it when a source uses multiple schemas with overlapping table names — for example Sales.Order and Purchasing.Order — so both can be staged without a name collision.
Related Settings
| Setting | Interaction |
|---|---|
| Append Record Source | The equivalent option for appending the Record Source code to the name |
| Object Name Pattern | Pattern-based override for the whole staged object name |
| Suffix Or Prefix Object | Determines whether the schema is prepended or appended |
Notes
- This setting is part of the Staging Naming settings category.
- The default value for this setting is
N.