How to Use a DAC Source System Parameter in an Action

Example of How to Use a DAC Source System Parameter in an Action

The following example illustrates how to use a DAC source system parameter in

defining an action.

Assume there is a source system parameter called COUNTRY (note: source system

parameter names are case sensitive). And, you use this parameter in an action using

the following SQL statement:

DELETE FROM TABLE1 WHERE COUNRY_NAME=‘@DAC_COUNTRY’

Assume that during the ETL process, COUNTRY gets resolved to Canada. The resulting

SQL that is executed by the DAC Server would be the following:

DELETE FROM TABLE1 WHERE COUNTRY_NAME=‘Canada’