Extract Transform and Load Projects

An Extract Transform and Load (ETL) project extracts data from multiple heterogeneous datasources, applies a series of transformation rules or functions to the extracted data to derive the data for loading into the end target, and loads the data into one or more IQ data targets.

• Project Customization
  You can create data transformation projects without using programming code or SQL statements.
• JavaScript
  Sybase IQ InfoPrimer supports the JavaScript language for expressions and procedures used in components, to transform and manipulate data within the transformation process.
• Datatypes and Data Formats
  Datasource datatypes are preserved during transformation.
• Unicode Support
  All components process and support Unicode and multibyte data. You can use Unicode-enabled transformation functions in calculations, scripts, and procedures.
• SQL Statements
  Most of the data delivered by Data Providers is defined by using SQL statements stored in the Query property. Sybase IQ InfoPrimer supports a modified set of the SQL92 standard.
• SQL Queries and Commands Execution
  You can enter and execute a SQL query or a series of SQL commands for databases associated with Source, Lookup, Staging, and Destination components.
• Project Execution
  You can run an ETL project using either simulation or execution mode.
• Project Simulation
  You can run an ETL project in simulation mode to monitor and validate your transformation process at every step.
• ETL Components
  ETL project components includes Source, Transformation, Lookup, Staging, Destination, and Loader components.
• Accessing the ETL Demonstration Projects and Jobs
  Connect to the demonstration repository to view examples of ETL projects and jobs.
• Simulating ETL Projects Interactively
  Start and simulate an ETL project interactively.
• Customizing SQL and Transformation Rules
  When setting up an ETL project or job, you can customize SQL queries for setting up source components, SQL commands for processing tasks, Expressions, conditions, and procedures to manipulate the transformation process.
• Creating and Simulating a Sample ETL Project
  Create and simulate a sample project that includes one or more data provider, data sink and a data calculator components.
• Using the Query Designer to Create Queries
  Use the Query Designer to generate select statements inside queries, lookup definitions, preprocessing and postprocessing SQL statements.
• Using Templates to Create ETL Projects and Jobs
  Use templates to automatically create projects and jobs.