Setting up a project or job includes a variety of tasks, some of which can be customized:
Entering SQL queries to set up the source components
Entering SQL commands for pre-processing and post-processing tasks
Entering expressions, conditions, and procedures to manipulate the transformation process
Although the format of the SQL commands is strongly dependent on the database system that is connected to the component, the format of the transformation language supported by Sybase IQ ETL (JavaScript) will not change, no matter what source or target system you are using in your projects.
The JavaScript expressions can be included in Square Bracket Notations (SBN expressions), which can considerably reduce your customization efforts. SBN expressions can be part of component properties (if the Evaluate property is activated for the specific property), SQL statements, or any pre- or post processing commands. An SBN expression resides inside an opening and a closing square bracket and is evaluated at “Runtime,” as opposed to constant expressions that are defined at “Design Time.”
