You can create a Datastore using memory as the database type. Memory Datastores are used to improve the performance of data flows in real time jobs as it stores the data in the memory to facilitate quick access and does not require to go to original data source.
A memory Datastore is used to store memory table schemas in the repository. These memory tables get data from tables in Relational database or using hierarchical data files like XML message and IDocs. The memory tables remain alive until the job is executed and the data in memory tables cannot be shared between different real time jobs.
To create Memory Datastore, follow the steps given below.
Step 1 − Click Create Datastore and enter the name of the Datastore “Memory_DS_TEST”. Memory tables are presented with normal RDBMS tables and can be identified with naming conventions.
Step 2 − In Datastore Type, Select Database and in the database type select Memory. Click OK.
Step 3 − Now go to Project → New → Project as shown in the screenshot given below.
Step 4 − Create a New Job by Right-clicking. Add Work flow and Data Flow as shown below.
Step 5 − Select a Template table and drag and drop to the work area. A Create table window will open.
Step 6 − Enter the name of the table and In Datastore, select Memory Datastore. If you want a system generated row id, select the create row id check box. Click OK.
Step 7 − Connect this Memory table to the dataflow and click Save All at the top.
To use a Memory Table as a Target −
Step 1 − Go to the local object library, click Datastore tab. Expand the Memory Datastore → Expand tables.
Step 2 − Select the Memory table you want to use as a source or target table and drag it to the work flow. Connect this memory table to as source or target in data flow.
Step 3 − Click the save button to save the job.