Skip to main content

Delete Object Name Pattern

The name to use for the Delete Objects when using Delete Detection. @@this_DEL will use the current object name (table name) and append _DEL at the end. Update this to use a specific naming convention for delete tables.

The pattern supports three tokens: @@this (the staged object's name, including the landing affix when the delete object is derived through the landing layer), @@rs (the Record Source code) and @@schema (the source object's schema). Leading and trailing underscores in the resolved name are trimmed. When the pattern is blank, the delete object falls back to the object name plus the Delete Detection Append Name suffix.

When to Change This Setting​

Keep the default @@this_DEL for the conventional {table}_DEL naming. Change it when your environment mandates a different naming convention for the tables that record detected deletes.

SettingInteraction
Delete Schema Name PatternThe equivalent pattern for the delete objects' schema
Delete Detection EnabledEnables delete detection overall
Object Name PatternThe equivalent pattern for regular staging tables

Notes​

  • This setting is part of the Staging Naming settings category.
  • The default value for this setting is @@this_DEL.