Talend-Open-Studio-v4-1-x-User-Guide-2011(7)

First Match .......................................................162

All Matches ......................................................162

6.3.3 How to use Inner join .................................162

6.3.4 How to use the All Rows option ................164

6.3.5 How to filter an input flow .........................164

6.3.6 How to remove input entries from table .....164

6.4 Mapping variables .............................................165

6.4.1 How to access global or context variables .166

6.4.2 How to remove variables ............................166

6.5 Using the expression editor ..............................166

6.5.1 How to access the expression editor ...........166

6.5.2 How to write code using the Expression Builder

168

6.6 Mapping the Output setting ............................171

6.6.1 Building complex expressions ....................172

6.6.2 Filters ..........................................................172

6.6.3 Rejections ...................................................173

6.6.4 Inner Join Rejection ....................................173

6.6.5 Removing Output entries ............................174

6.6.6 Handling errors ...........................................174

6.7 Describing the schema editor ..........................175

6.8 Solving memory limitation issues in tMap use 176

6.9 Handling lookups ..............................................178

CHAPTER 7

Managing Metadata .................................181

7.1 Objectives ...........................................................182

7.2 Setting up a DB connection ..............................182

7.2.1 Step 1: General properties ..........................182

7.2.2 Step 2: Connection .....................................183

7.2.3 Step 3: Table upload ...................................185

7.2.4 Step 4: Schema definition ...........................188

7.3 Setting up an FTP connection ..........................189

7.3.1 Step 1: General properties ..........................189

7.3.2 Step 2: Connection .....................................190

7.4 Setting up a JDBC schema ...............................191

7.4.1 Step 1: General properties ..........................191

7.4.2 Step 2: Connection .....................................191

7.4.3 Step 3: Table upload ...................................193

7.4.4 Step 4: Schema definition ...........................193

7.5 Setting up a SAS connection............................ 194

7.5.1 Prerequisites ...............................................194

7.5.2 Step 1: General properties ..........................194

7.5.3 Step 2: Connection .....................................194

7.6 Setting up a File Delimited schema .................196

7.6.1 Step 1: General properties ..........................196

7.6.2 Step 2: File upload ......................................196

7.6.3 Step 3: Schema definition ...........................197

7.6.4 Step 4: Final schema ...................................199

7.7 Setting up a File Positional schema .................200

7.7.1 Step 1: General properties ..........................201

7.7.2 Step 2: Connection and file upload ............201

7.7.3 Step 3: Schema refining .............................202

7.7.4 Step 4: Finalising the end schema ..............202

7.8 Setting up a File Regex schema ........................2037.8.1 Step 1: General properties ...........................2037.8.2 Step 2: File upload ......................................2037.8.3 Step 3: Schema definition ...........................2047.8.4 Step 4: Finalizing the end schema ..............2047.9 Setting up an XML file schema .......................2047.9.1 Setting up an XML schema for an input file .....205Step 1: General properties ................................205Step 2: Setting the type of schema (input) ........206Step 3: Uploading the input file ........................207Step 4: Defining the schema .............................208Step 5: Finalizing the end schema ....................2107.9.2 Setting up an XML schema for an output file ...211Step 1: General properties ................................211Step 2: Setting the type of schema (output) ......212Step 3: Defining the output file ........................213Step 4:Defining the schema ..............................215Step 5: Finalizing the end schema ...................2167.10 Setting up a File Excel schema .......................2177.10.1 Step 1: General properties .........................2187.10.2 Step 2: File upload ....................................2187.10.3 Step 3: Schema refining ............................2197.10.4 Step 4: Finalising the end schema .............2207.11 Setting up a File LDIF schema ......................2217.11.1 Step 1: General properties .........................2217.11.2 Step 2: File upload ....................................2217.11.3 Step 3: Schema definition .........................2227.11.4 Step 4: Finalising the end schema ............2237.12 Setting up an LDAP schema ...........................2237.12.1 Step 1: General properties .........................2247.12.2 Step 2: Server connection .........................2247.12.3 Step 3: Authentication and DN fetching ...2247.12.4 Step 4: Schema definition .........................2267.12.5 Step 5: Finalising the end schema .............2277.13 Setting up a Salesforce schema .......................2287.13.1 Step 1: General properties .........................2297.13.2 Step 2: Connection to a Salesforce account ....2297.13.3 Step 3: Schema refining ............................2297.13.4 Step 4: Finalising the end schema .............2307.14 Setting up a Generic schema ...........................2317.14.1 S …… 此处隐藏：4501字，全部文档内容请下载后查看。喜欢就下载吧 ……