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

Vantage Analytics Library User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Vantage Analytics Library
Release Number
2.2.0
Published
March 2023
Language
English (United States)
Last Update
2024-01-02
dita:mapPath
ibw1595473364329.ditamap
dita:ditavalPath
iup1603985291876.ditaval
dita:id
zyl1473786378775
Product Category
Teradata Vantage

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