User`s guide

Contents
User’s Guide v
Using multiple engines to reduce job execution time..................... 61
Defining multi-engine jobs....................................................... 63
Executing multi-engine jobs .................................................... 63
Analyzing performance data .......................................................... 63
Performance data model and content ..................................... 64
Example reports ...................................................................... 65
CHAPTER 6 Components .................................................................................. 69
Overview ........................................................................................ 69
Setting required properties ...................................................... 70
Setting up a component .......................................................... 71
Entering database connection parameters.............................. 71
Connecting to a SQLite database ........................................... 75
Providing descriptions for components ................................... 76
Adding component variables to a component ......................... 76
Evaluating SBN expressions................................................... 77
Encrypting properties .............................................................. 77
Modifying components ............................................................ 78
Data blocks and visualization.................................................. 78
Stepping a component multiple times ..................................... 78
Managing port structures......................................................... 79
Source components ....................................................................... 81
DB Data Provider Full Load..................................................... 81
DB Data Provider Index Load.................................................. 83
Text Data Provider .................................................................. 85
XML via SQL Data Provider .................................................... 88
Transformation components .......................................................... 93
The Data Calculator ................................................................ 93
Character Mapper ................................................................... 99
Using Lookup components........................................................... 101
DB Lookup component.......................................................... 101
DB Lookup Dynamic component........................................... 104
Staging components .................................................................... 107
DB Staging component ......................................................... 107
Processing components............................................................... 109
Data Splitter component........................................................ 109
Destination components............................................................... 110
DB Data Sink Insert component............................................ 110
DB Data Sink Update component ......................................... 113
DB Data Sink Delete component........................................... 115
Text Data Sink....................................................................... 116
DB Bulk Load Sybase IQ component.................................... 119
Job components........................................................................... 121
Start component.................................................................... 121