You can create data transformation projects without using programming code or SQL statements. For example, you can:
Use the Query Designer to generate select statements inside queries, lookup definitions, preprocessing and postprocessing SQL.
Use the data mapping features of the links between the components to map attributes between data sources and data sinks.
Use the built-in Create Table From Port command of the component you are using, to create temporary or persistent staging tables, or to create tables in the destination database.
Use the Content Explorer to browse schema information and data content of all connected data sources.
Use the XML via SQL Data Provider component to read hierarchical XML documents and automatically generate a relational structure.
Schedule execution of projects and create jobs within Sybase ETL Development.
Additionally, when you have complex data transformation requirements, you can use:
Manually optimized SQL select statements to adjust the data extraction process.
SQL statements to apply data manipulation commands in different phases of the transformation.
JavaScript to write procedures, perform complex calculations, or manipulate objects in the operating system environment.
Indirection via expressions to dynamically control your projects by using environment or user variables.
