StoreIndexMap

table category: table-control no `||` resultSize: 1

Persists an index from the current CDM table to disk so a later run can reuse it.

Storing an index map lets you split an ETL across multiple Rabbit-in-a-Hat files. After a run, the named index and its mapped values are serialised to the directory configured under rabbit configuration.index directory. A subsequent run loads it automatically, which is essential when the second run uses GetCDMTableId to map source IDs to CDM IDs assigned by the first run.

Parameters

1 — index Mandatory — accepts: array of fields (:-notation)

Fields that constitute the index key.

2 — values Mandatory — accepts: array of fields (:-notation)

Fields whose values are stored against the index.

Requires

• All referenced CDM fields must exist.

Examples

StoreIndexMap([:person_source_value], [:person_id])

See also

StoreSequence