|
| 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. |
| RegularExpression | | Used to check the value of a column based on a pattern defined by a regular expression. |