|
| AllowNulls | | Determine whether null values are allowed in the column.
True = (Default) Nulls are allowed.
False = Nulls are not allowed.
|
| ColumnNames | | (Required) A list of column names, separated by commas. For example:
OrderID, CustomerID, EmployeeID, OrderDate |
| DefaultColumnValue | | The default value to use if the column does not contain value. |
| ExceptionDataID | | Defines an ETL ID value that can be used to address the exception data that was removed by the filter.
The value of this attribute may be referenced by a DataLayer.ETL, LoadDbTable, SaveData, or any other element that supports the EtlElementID attribute. |
| ID | | (Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition. |
| MaxValue | | The maximum value of the range. |
| MinValue | | The minimum value of the range. |
| NumberFormat | | WholeNumber |
| DecimalNumber |
| Any |
| Used to check for a particular number format: WholeNumber, DecimalNumber, or AnyNumber.
Defaults to AnyNumber. |
| NumberType | | PostiveNumber |
| OddNumber |
| NegativeNumber |
| EvenNumber |
| Any |
| Used to check for a particular number type: OddNumber, EvenNumber, PositiveNumber, NegativeNumber, AnyNumber.
Since the concept of odd or even numbers only applies to whole numbers (integers), the system will automatically set the format to "WholeNumer" when type is odd or even.
Defaults to AnyNumber. |