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 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.