Function Field Mapping: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
No edit summary
No edit summary
Line 20: Line 20:
|-
|-
| SQL Lookup
| SQL Lookup
| Performs a database lookup on the Destination database. Supply a SQL SELECT statement, will return the first column from the first row. More on Server-Side Lookups
| Performs a database lookup on the Destination database. Supply a SQL SELECT statement, will return the first column from the first row. More on [[SQL Lookups|Server-Side Lookups]]
|-
|-
| Smart Lookup
| Smart Lookup
Line 29: Line 29:
|-
|-
| Scripted Value
| Scripted Value
| Allows the user to write a VBScript function to perform custom operations for each field. The VBScript function provides a skeleton function called “ScriptedField”. The value that will be used is whatever is returned out of this function. More on Scripted Values
| Allows the user to write a VBScript function to perform custom operations for each field. The VBScript function provides a skeleton function called “ScriptedField”. The value that will be used is whatever is returned out of this function. More on [[Scripted Values]]
|-
|-
| SalesLogix ID
| SalesLogix ID

Revision as of 22:51, 5 November 2014

To begin creating a Function Field, you can do this 3 ways.

1. Select “Function Field” from the Origin Fields drop-down.To begin creating a Function Field, select “Function Field” from the Origin Fields drop-down.

2. OR click the ellipsis inside the Operation column (or double-click this field).

3. OR click the + button

Select from the following types of Function Fields, more information is provided below.

Option Name Description
SQL Lookup Performs a database lookup on the Destination database. Supply a SQL SELECT statement, will return the first column from the first row. More on Server-Side Lookups
Smart Lookup Performs a lookup on the destination, returning a single field’s value. Allows caching of results so the multiple runs of the same lookup don’t have to make round-trips to the destination. This cache is stored in memory, so it’s a good idea to only use it when there is a high chance of the same queries, otherwise an out of memory exception could occur when caching large amounts of data.
Hardcoded Value Allows the user to specify a static value, although you can also insert aVariable here as well. It is not necessary to include quotes for text/string values.
Scripted Value Allows the user to write a VBScript function to perform custom operations for each field. The VBScript function provides a skeleton function called “ScriptedField”. The value that will be used is whatever is returned out of this function. More on Scripted Values
SalesLogix ID For OLE DB destinations using the SalesLogix OLE DB adapter, this function will be available. Automatically generated a new Saleslogix ID for this field, based on the Stage’s destination table.
Format Conversion Convert source data to another format. Options are:Rich Text (RTF) -to- Plain TextHTML -to- Plain TextBase64 -to- BinaryBinary -to- Base64File -to- Base64
Current Date/Time Inserts the current Date/Time at the server. Formats include Date/Time, Date Only, Time Only.