Extended Systems OneBridge 4.1 Guía de usuario descargar pdf (Pagina 10)

x Sybase IQ ETL 4.1

1 2 ... 5 6 7 8 9 10 11 12 13 14 15 ... 221 222

Sybase IQ ETL 1
DC00608-01-0410-01 2
October 2006 2
Contents 3
User’s Guide vii 7
User’s Guide ix 9
Sybase IQ ETL 4.1 10
About This Book 11
Sybase IQ ETL 4.1 12
About This Book 13
If you need help 14
Projects and jobs 16
Component concepts 16
Running a project 17
Customizing a project 17
Understanding repositories 18
CHAPTER 1 Sybase IQ ETL 19
Unicode support 20
Expressions 20
Internal database 20
8 Sybase IQ ETL 4.1 22
Sybase IQ ETL Development 23
Using the Navigator 24
Administering the repository 25
Administering user accounts 27
Using the Properties section 28
Using the Design section 29
Adding components 30
Customizing preferences 31
User’s Guide 19 33
20 Sybase IQ ETL 4.1 34
Getting Started 35
Creating your first project 36
Adding a data sink 37
Adding a data calculator 38
Simulating the project 39
26 Sybase IQ ETL 4.1 40
Projects and Jobs 41
Managing projects 42
User’s Guide 29 43
❖ To simulate a project 43
Viewing current mappings 45
Managing port attributes 46
Viewing a simulation flow 46
User’s Guide 33 47
User’s Guide 35 49
Managing jobs 50
Executing a job 51
Cancelling job execution 52
Creating Jobs 52
Building a migration template 54
User’s Guide 41 55
Managing a migration template 57
44 Sybase IQ ETL 4.1 58
Advanced Concepts and Tools 59
Opening Content Explorer 60
Using the Design area 60
Creating queries 61
Content Explorer 62
User’s Guide 49 63
Evaluate property is 65
Including variables 66
Using functions 67
Using Square Bracket Notation 68
Entering SQL statements 68
Entering queries 69
Validating queries 69
Query designer 69
SELECT * FROM 70
PRODUCT [uTracelevel(5)] 70
User’s Guide 57 71
Features 71
Edit and Debug mode 72
User’s Guide 59 73
❖ To step through the code 73
❖ To step to a Breakpoint 73
Special JavaScript features 74
Analyzing performance data 77
Example reports 79
Project execution history 80
User’s Guide 67 81
68 Sybase IQ ETL 4.1 82
Components 83
Setting required properties 84
Setting up a component 85
Overview 86
Creating a SQLite table 89
Evaluating SBN expressions 91
Encrypting properties 91
Modifying components 92
Data blocks and visualization 92
Managing port structures 93
DB Data Provider Index Load 97
Text Data Provider 99
Properties 100
CHAPTER 6 Components 101
XML via SQL Data Provider 102
Optional properties 103
Source components 104
Transformation components 107
Character Mapper 113
Using Lookup components 115
Required properties 116
DB Lookup Dynamic component 118
Staging components 121
Processing components 123
Destination components 124
DB Data Sink Update component 127
DB Data Sink Delete component 129
Text Data Sink 130
Job components 135
Synchronizer component 136
Multi-Project component 137
Finish component 138
Error component 138
Function Reference 139
Aggregation functions 140
Bit functions 141
Boolean functions 142
Sybase IQ ETL 4.1 144
1 if the parameter is null 145
Conversion functions 146
Date and time functions 151
now modifier 154
Errorhandling functions 163
File functions 166
Formatting functions 168
Fuzzy search functions 170
Lookup functions 171
IF construct: 172
Miscellaneous functions 174
166 Sybase IQ ETL 4.1 180
168 Sybase IQ ETL 4.1 182
170 Sybase IQ ETL 4.1 184
Network functions 185
Numeric functions 186
Script functions 191
String functions 191
Operator functions 200
Trigonometric functions 202
Sybase ETL Server 205
Communication 206
Using the server 206
GRID Engine Server 206
Stop a server 207
Install as a System Service 207
Troubleshooting 208
Command line parameters 209
INI file settings 210
Default.ini 211
GridNode.ini 211
198 Sybase IQ ETL 4.1 212
Queuing and Executing 213
Process Calls 213
Configuring ProcessQ calls 214
202 Sybase IQ ETL 4.1 216
204 Sybase IQ ETL 4.1 218
206 Sybase IQ ETL 4.1 220
208 Sybase IQ ETL 4.1 222

Comentarios a estos manuales

Sin comentarios

Extended Systems OneBridge 4.1 Guía de usuario Pagina 10

Comentarios a estos manuales

Relacionado con productos y manuales para Servidores Extended Systems OneBridge 4.1