Rx Logix Documentation

Lookup Settings SELECT ‘DLP_OWNER.’ || VIEW_NAME as TABLE_NAME from SYS.ALL_VIEWS WHERE VIEW_NAME LIKE ‘VW_RX_%’ and OWNER = ‘DLP_OWNER’ ;

Iterate and Copy @activity(‘LookupTableList’).output.value

ForEach @pipeline().parameters.tableList

Copy Data Source SELECT * FROM @{item().TABLE_NAME}

Copy Data Sink Oracle Table @{replace(item().TABLE_NAME,’VW_RX_’,’’)}

Copy Data Pre-copy Script TRUNCATE TABLE @{replace(item().TABLE_NAME,’VW_RX_’,’’)} DROP STORAGE