Object Name Pattern
Specific override behavior for the object name for staging tables.
When set, the names of staged objects (Staging, Persistent Staging Area and External tables) are built from this pattern instead of the standard derivation. The pattern supports four tokens:
| Token | Resolves to |
|---|---|
@@this | The object's standard derived name |
@@rs | The Record Source code of the connection |
@@stage | The stage affix for the target (external/staging affix, depending on platform and stage) |
@@schema | The object's original schema |
When the pattern is blank (the default), the standard naming applies.
When to Change This Setting
Set it when your environment mandates a specific object naming convention for staging tables that the affix-based settings cannot express, for example @@rs_@@schema_@@this to combine record source, schema and name into one identifier.
Related Settings
| Setting | Interaction |
|---|---|
| Schema Name Pattern | The equivalent pattern for the schema name |
| Delete Object Name Pattern | The equivalent pattern for delete-detection objects |
| Append Schema STG | Affix-based alternative that appends the source schema to the name |
Notes
- This setting is part of the Staging Naming settings category.