Sequential File stage: Output link properties tab
The Properties tab allows you to specify properties for the output link. These dictate how incoming data is read from the sequential files.
Some of the properties are mandatory, although many have default settings. Properties without default settings appear in the warning color (red by default) and turn black when you supply a value for them.
The following table gives a quick reference list of the properties and their attributes. A more detailed description of each property follows.
Category/Property | Values | Default | Mandatory? | Repeats? | Dependent of |
---|---|---|---|---|---|
Source/File | pathname | N/A | Y if Read Method = Specific Files(s) | Y | N/A |
Source/File Pattern | pathname | N/A | Y if Read Method = Field Pattern | N | N/A |
Source/Read Method | Specific File(s)/File Pattern | Specific Files(s) | Y | N | N/A |
Options/First Line is Column Names | True/False | False | Y | N | N/A |
Options/Missing File Mode | Error/OK/Depends | Depends | Y if File used | N | N/A |
Options/Keep file Partitions | True/False | False | Y | N | N/A |
Options/Reject Mode | Continue/ Fail/Save | Continue | Y | N | N/A |
Options/Report Progress | Yes/No | Yes | Y | N | N/A |
Options/Filter | command | N/A | N | N | N/A |
Options/File Name Column | column name | N/A | N | N | N/A |
Options/Read first rows | number | N/A | N | N | N/A |
Options/Row number column | column name | N/A | N | N | N/A |
Options/Number Of Readers Per Node | number | 1 | N | N | N/A |
Options/Schema File | pathname | N/A | N | N | N/A |
Options/Strip BOM | True/False | FALSE | N | N | N/A |