Lesson 1: RETL product overview
Lesson objectives
Introduction to RETL
Enhancements of 11.0 versions of RETL
4
4
5
6
Lesson 2: RETL technical specifications
Lesson objectives
Supported operating systems
Database management systems
Data integration
7
7
8
8
8
Module 2: Installation and system configuration
9
Lesson 1: Installation
Lesson objectives
RETL installation procedure
Upgrading from a 10.x release of RETL
Set up
The RETL package verification tool (verify_retl)
Backwards Compatibility Notes
RFX Command line options
10
10
11
12
12
13
14
18
Lesson 2: Configuration
Lesson objectives
Configuration field descriptions
Multi-byte character support
21
21
22
26
Module 3: RETL interface
27
Lesson 1: Schema file
Schema file requirements
Schema file XML specification
Delimited record schema
Fixed length record schema
Nullvalue
Configuration to print schema output in schemafile format
28
29
30
32
33
34
35
Module 4: RETL program flow
37
Lesson 1: RETL program flow overview
Lesson objectives
The general flow
A simple flow
A more complex flow
Online help
38
38
39
40
42
43
Module 5: RETL operators
45
Lesson 1: Database operators
Lesson objectives
ORAREAD
ORAWRITE
DB2WRITE
TERAFEREAD
TERAWRITE
Read-write operators XML specification table
Tag usage examples
46
46
47
47
47
47
48
48
63
Lesson 2: input and output operators
Lesson objectives
DEBUG
NOOP
EXPORT
IMPORT
Input and output operators XML specification table
Tag usage examples
65
65
66
66
66
66
67
68
Lesson 3: Join operators
Lesson objectives
INNERJOIN
LEFTOUTERJOIN
LEFTOUTERJOIN
FULLOUTERJOIN
LOOKUP
Special notes about Join operators
Tag usage examples
70
70
71
71
71
71
71
72
74
Lesson 4: Sort and merge operators
Lesson objectives
COLLECT and FUNNEL
SORTCOLLECT and SORTFUNNEL
HASH
SORT
MERGE
Sort and merge operators XML specification table
Tag usage examples
76
76
77
77
77
77
77
78
80
Lesson 5: Mathematical operators
Lesson objectives
BINOP
GROUPBY
GROUPBY on multiple partitions
Mathematical operators XML specification table
Tag usage examples
81
81
82
82
82
83
84
Lesson 6: Structures and data manipulation operators
Lesson objectives
CONVERT
FIELDMOD
FILTER
GENERATOR
Structures and data manipulation operators XML specification table
Tag usage examples
87
87
88
89
90
90
91
104
Appendix
111
Appendix A - Default Conversations
Appendix B - Troubleshooting guide
Appendix C - Database configuration and troubleshooting guide
Appendix D - FAQs
Appendix E - RETL 11.0-specific FAQs
