COLLECT DEMOGRAPHICS Examples | VantageCloud Lake - COLLECT DEMOGRAPHICS Examples - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Example: Collect Demographic Estimates

Collect demographic estimates on table_1 in database db_1 and write the results into the DataDemographics table of user-defined QCD MyQCD.

COLLECT DEMOGRAPHICS FOR db_1.table_1 INTO MyQCD;

Example: Update Demographic Estimates

An entry already exists in the DataDemographics table for the specified table, then the entry is updated with the collected demographic estimates. The value of TimeStamp is updated to reflect the current time.

COLLECT DEMOGRAPHICS FOR db_1.table_1 INTO MyQCD; /* Inserts data
into DataDemographics table of MyQCD */
COLLECT DEMOGRAPHICS FOR db_1.table_1 INTO MyQCD; /* Updates data
in DataDemographics table of MyQCD */