Two Input Tables
call td_analyze ( 'overlap', 'database = val_source, val_source; tablename = customer, customer_analysis; columns = {cust_id}, {cust_id};' );
One-Part Partial Key for Some Input Tables
Some of the seven input tables use the one-part key cust_id.
call td_analyze ( 'overlap', 'database = val_source, val_source, val_source, val_source, val_source, val_source, val_source; tablename = customer, checking_acct, checking_tran, credit_acct, credit_tran, savings_acct, savings_tran; columns = {cust_id}, {cust_id}, {cust_id}, {cust_id}, {cust_id}, {cust_id}, {cust_id};' );
Two-Part Key for Three Input Tables
The three input tables use the two-part key composed of cust_id and tran_id.
call td_analyze ( 'overlap', 'database = val_source, val_source, val_source; tablename = checking_tran, credit_tran, savings_tran; columns = {cust_id,tran_id}, {cust_id,tran_id}, {cust_id,tran_id};' );