|
Create Cursor |
Scroll |
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.
