User`s guide

Index
User’s Guide 207
adding a data sink 23
controlling multiple data streams 35
copying a project 28
creating a project 27
creating data transformation projects 3
creating data transformation projects, complex 4
creating your first project 22
customizing a project 3
defined 2
deleting a project 28
executing a project 28
managing projects 27
mappings 31
modifying a project 28
renaming a project 28
resetting execution properties 28
running a project 3
simulating a project 3
simulating and executing a project 29
starting a simulation 25
unlocking a project 28
viewing simulation flow 32
Properties section
Development desktop 14
R
reports
analyzing performance data 63
examples 65
repositories
adding 11
administering 11
closing a repository connection 11
navigating 12
opening 11
overview 4
running a project 3
modes 3
Runtime Manager 49
S
SBN expressions 77
scheduling tasks
managing job schedules 50
Runtime Manager 49
script functions
uEvaluate 177
server
components 191
ETL 191
GRID architecture 191
GRID engine as a Windows System Service 193
INI file settings 196
overview 2
simulating a project 3, 25
source components
DB Data Provider Full Load 81
DB Data Provider Index Load 83
Text Data Provider 85
XML via SQL Data Provider 88
SQL
customizing SQL and transformation rules 51
entering SQL statements 54
including variables 52
overview 5
Query Designer 55
using expressions and procedures 52
validating queries 55
Square Bracket Notation 54
example 54
staging components
DB Staging 107
Start component 121
starting IQ ETL Development 21
stepping a component
record-by-record 2
string functions
uAsc, uUniCode 177
uCap 178
uChr, uUniChr 178
uConcat, uCon 179
uJoin 179
uLeft 180
uLength, uLen 180
uLower, uLow 181
uLPos 181
uLStuff 182
uLTrim 182