Sybase IQ InfoPrimer Use Cases

Review the use cases for the various tasks you may need to perform using the Sybase IQ InfoPrimer tool. Each use case includes a graphical and sequential representation of the tasks to be performed, along with callouts. These callouts identify and provide references to the sections that include detailed information on how to perform each of the tasks.

• Separating Development from a Production Environment
  Goal: Separate a development environment from a production environment.
• Migrating Data to Sybase IQ
  Goal: Migrate data from another database instance to Sybase IQ, if database schema is the same. Migrate data from Oracle, Adaptive Server Enterprise (ASE), Microsoft SQL Server, flat files, and other supported datasources to a Sybase IQ database, using an EL project.
• Performing Incremental Loads
  Goal: Update data in the IQ target with changed data from the source. This assumes changed data is captured in a database or data files.
• Merging Data from Different Sources
  Goal: Populate target tables with joined data from multiple heterogeneous sources.
• Loading Dimensions Reflecting the Present
  Goal: Load dimension tables. Maintaining data in a dimension table typically requires inserting new and updating changed records (slowly changing dimensions type 1 and higher). This use case assumes that changed data is already staged in IQ.
• Loading Dimensions Tracking History
  Goal: Track history of data. A special type of dimension table tracks historic data (slowly changing dimensions type 2 and higher). For existing records, these tables expect an update and an insert.
• Loading Facts
  Goal: Maintaining data in a fact table typically requires inserting new data and looking up keys from dimension tables. This use case assumes that new data is already staged in IQ and dimension tables have already been updated.
• Setting up an ELT Job
  Goal: Create a job that performs all necessary steps for loading the final target.
• Creating a Repository
  Goal: Access and define the ODBC datasource for an empty SQL Anywhere 11 repository.