DAC:Timestamp Type Parameter

Procedure to define a parameter using the Timestamp data type. This procedure applies to parameters defined at both the source system and task levels.
To define a Timestamp type parameter:

1. Do one of the following:
   
   • To define a source system parameter, from the Views menu, select Design, and then select Source System Parameters.
     
   • To define a task level parameter, from the Views menu, select Design, then select Tasks, and then click the Parameters subtab.
     
2. Click New.
   
3. Enter a parameter name.
   
4. Select the Timestamp data type.
   
5. Click in the Value field to open the Enter Parameter Value dialog.
   
6. Select one of the following options:
   
   • Static. This option specifies a value that remains constant for all ETL runs.
     
   • Runtime. This option specifies the value will be updated by the DAC before each ETL run.
     
   • SQL. This option
     
7. If you selected the Static option:
   
   1. Click in the Date field to open the Date dialog.
      
   2. Enter a data and time, click OK.
      
8. If you selected the Runtime option:
   
   1. Click in the Value field to open the Enter Parameter Value dialog.
      
   2. Select a Variable from the list.
      
   3. From the Function list, select a format to which the DAC will convert the date. If you select Custom, enter a custom date format.
      If you select SQL Syntax or SQL Syntax (Date Only), select a Connection Type.
      
9. If you selected the SQL option:
   
   1. Click in the SQL field to open the Enter Parameter Value dialog.
      
   2. Select a Logical Data Source from the list.
      
   3. Enter the parameter definition and click OK.
      
10. Click OK to close the Enter Parameter Value dialog.
    
11. (Optional) To inactivate the parameter, select Inactive.
    
12. Click Save.