User`s guide

Destination components
116 Sybase IQ ETL 4.1
Post-processing SQL
This property provides one or more SQL statements to be executed when all
components finished execution.
Opening Attribute Quote
The open quote (“x) character begins the attribute names in SQL statements.
Closing Attribute Quote
The close quote (x”) character ends the attribute names in SQL statements.
See section “Entering database connection parameters” on page 71 for more
information on the previous properties and the following properties:
• Database
• Schema
• Standardize Data Format
• Database Options
There is no impact on Simulation sequence.
Projects in DemoRepository and Help Flash movie: Demo DB Datasink
Delete.
Text Data Sink
The Text Data Sink component lets you write text data files in delimited or
fixed-length format.
Use this component to write transformation results to a text data file.
The properties of the Text Data Sink can be changed either from within the Text
Data Sink component window or by manipulating the items in the Property
section. Click Properties to open the component window from the Property
section.
❖ To add a Text Data Sink component to a project
1 Add the component.
2 Enter a file name for the destination file.
3 Describe the file structure: Type, Line Delimiter, Column Delimiter.