Page tree
Skip to end of metadata
Go to start of metadata

Each Project should have at least the following Global Variables:

  • $G_LOADTYPE VARCHAR(5): {FIRST, DELTA} indicates if the current load is an Initial or Delta load
  • $G_SDATE date: The lowest date to take data from for this load
  • $G_EDATE date: The highest date
  • $G_DEFAULT_TEXT varchar(1): {?} A character all Strings will get assigned in case a null value is found, e.g. inside a Foreign Key
  • $G_DEFAULT_NUMBER int: {-1} same, but for numbers
  • $G_DEFAULT_DATE date: {9999.12.31} and for dates
  • $G_LANGUAGE varchar(2): In case text is available in multiple languages, take it for this one
  • $G_REBUILD_INDEXES varchar(1): {Y, N} See the PreLoad Stored Procedure
  • $G_FAILURES int: See the PostLoad Stored Procedure

These variables are set at the properties at the job to defaults, can hence be overwritten when executing a job or scheduling it. For safety reasons, a first script - the Initialize Script - should gracefully care about cases where variables have not been set correctly. see next chapter.

  • No labels