You can create data transformation projects without manually entering a single line of programming code or SQL statement, for example:
To generate SELECT statements inside Queries, Lookup Definitions, Pre- and Post Processing SQL, use the Query Designer.
To freely map attributes between data sources and data sinks, use the data mapping features of the links between the components.
To create temporary or persistent staging tables, use the built-in Create Table from port command of the respective component.
To create tables in the destination database, use the built-in Create Table from port command of the respective component.
To browse both schema information and data content of all connected data sources, use the Content Explorer.
To read hierarchical XML documents and generate a relational structure automatically, use the XML from the SQL component.
To schedule the execution of your projects, you can create Jobs within the Sybase IQ ETL desktop.
To deal with complex data transformation requirements, familiarize yourself with Sybase IQ ETL concepts.
For example, you can:
Use manually optimized SQL SELECT statements to adjust and fine-tune your data extraction process.
Use SQL to apply data manipulation commands inside pre- and post-processing commands.
Use JavaScript to write procedures, do complex calculations, or manipulate objects in the operating system environment.
Use indirection in expressions (Square Bracket Notation) to dynamically assign values to expressions to control your projects by using environment or user variables.
