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