update_child_tables: Update child tables using inserted foreign keys

In vimc/dettl: Data Extract, Transform, Test and Load

Update child tables using inserted foreign keys

Description

Update child tables using inserted foreign keys

Usage

update_child_tables(
  tables,
  table_key_pair,
  old_key_values,
  new_key_values,
  parent_table
)

Arguments

tables	List of tables to be updated.
table_key_pair	List of child tables and the foreign key field.
old_key_values	Old values of referenced key, how foreign key is currently identified in child table.
new_key_values	New values of referenced key, what foreign key should be updated to.
parent_table	The name of the table just updated

Value

The updated tables

vimc/dettl documentation built on Oct. 6, 2022, 2:13 p.m.