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"
Notes:
- This setting is part of the Staging Naming settings category.
- The default value for this setting is
N
.