When to use this connector
The Memory Connection is used to store the extracted dataset. For example, the dictionary table that can be used to lookup data in.
Read about using Memory Connection for lookup.
Process
To create a Memory Connection:
Step 1. Open the Connections window.
Step 2. Click add connection.
Step 3. Type in memory and select the Connection type.
Step 4. Name and save the Connection.
Tip: While you can create multiple memory Connections, it really makes sense to have just one.