Sybase IQETL 简介.ppt

* * IQ ETL on the edge implies that it is a DI Suite or 3rd party tool target * * * * * The GRID architecture consists of several independent GridNode instances within a network. Each GridNode instance exposes certain services to all other peer nodes. Currently GridNode is mainly hosting the Engine Service that allows execution of Sybase IQ ETL projects. Sybase IQ ETL uses the GRID Network Nodes for parallel execution of projects and jobs for gaining a much better scalability of transformation speed. * Design Section: Build projects Build jobs Allow Multi-Engine Execution for GRID Jobs Step/Execute GRID projects Print Project Modify/Swap Project Navigator Section: Open/Close Repositories Create/Open Project and Job Delete/Rename Project/Job Execute GRID Project/Job on GRID Engine Transfer/Copy Project between repositories User accounts Reset Execution Properties (DB Data Provider Index Load only) Component Store: Add componets Properties Section: Maintain component properties Add Component/Reference variables Open component window Allow EVALUATION of selected property (Square Bracket Notation allowed = Indirection) Allow property to be parameterized EXTERNALly Allow property to be encrypted in the repository Assistant Assistant provides general help information regarding the missing steps inside the project Switch ON/OFF in File-Preferences Help Content: User Guide Javahelp UTL Reference User Guide as PDF License Manager Variety of Flash movies to demonstrate ETL feature * In Step/Simulation Mode you can: Step through a project record block by record block View input data and output data inside a component Modify properties or calculations on-the-fly Re-step a component after modifying a calculation or property What-if scenarios Step up to a specific component Multi-step through the project * Entire projects are executed within jobs Multiple projects can be executed within a single job. Jobs can be scheduled to run at specific times. Jobs can NOT be simulated