12.2.9 Parameters in EDD Definition

While defining an EDD, the parameter can be used as a placeholder in a data filename.

For example: Consider a table with two columns: Account number and Balance.

Table 12-4 EDD Parameters Example

Account Number Balance
A1 1000
A2 1000
A3 1000
A1 1000
A2 1500
A3 1500

In this example, a customer has three accounts (A1, A2, and A3).

The customer has deposited different amounts on January 1st and 2nd 2014. The CSV data files can be created for those two dates as follows:
  • The account transaction for January 1st, 2014 is saved as td_contracts_/01012014/.csv
  • The account transaction for January 2nd, 2014 is saved as td_contracts_/01022014/.csv

If a parameter, MISDATE, is defined as a Runtime, this can be used as a placeholder that substitutes date in mmddyyyy format. That is, the data filename can be mentioned as td_contracts_%#MISDATE%.csv. When this file is called, it substitutes the date in the file name, dynamically, in the Runtime.

Parameter Data Types need not always be Runtime. They can be Constants or values like Current Date, which can also be used to substitute a value in a data filename.