Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In some cases, multiple procedures will be required to update a table. In such cases, it is best to create a top-level procedure that is seen by the scheduler as the 'Update' procedure. This procedure can in turn, call other procedures.

Anchor
procedure_placeholders
procedure_placeholders
Procedure Placeholders

The following procedure placeholders are used for compiling procedures to the required target database location and referencing other data warehouse objects defined in the RED metadata. Placeholders are particularly useful when deploying between environments ensuring the objects referenced are fully qualified to suit the environment being deployed to:

...