Cursors allow you to reference data from datastores other than the primary source input datastore. Cursors permit essentially any SQL statement to be executed against a target RDMMS.
With Cursors, you can perform operations such as:
- Translating field values from code files/tables.
- Retrieving related data from other datastores
- Performing validation of field values prior to mapping them to target fields.
- Substitution of field values based on a correlating value from another datastore.