User`s guide

Source components
88 Sybase IQ ETL 4.1
Working with fixed-length file type
When a file has been qualified as fixed-length, the Add Column option in the
Output Port Content area is activated. For each column to be added, click Add
Column and edit Column Name, From Position and To Position. Or, you can
select the range of the column to be specified in the upper File Content section.
Right-click and select Assign Position to Column. Then, enter the Column
Name. The position parameters are preset according to the position of the
selected area in the line.
Impact on Simulation sequence
There is no impact on Simulation sequence. For more information, view the
Help Demo Transfer German Customers.
XML via SQL Data Provider
The XML via SQL Data Provider loads the data from a hierarchical XML
document into a relational schema. This schema can be queried via SQL like a
relational database.
Figure 6-1: XML via SQL Data Provider
Using the built-in SQL-based XML Port Manager, you can define one or more
output data streams. To validate the XML source file, you can provide either a
XML Schema file or a DTD description file.