Examples | Overlap | Vantage Analytics Library - Examples - Vantage Analytics Library

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};'
);