Correlation Example | Teradata Vantage - Correlation Example: VIF ('false'), Omit PartitionColumns - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

This example does not use VIF and omits the PartitionColumns syntax element, so the function determines the correlation values for the overall population and does not group the data by state.

SQL Call

SELECT * FROM Correlation (
  ON corr_input AS InputTable
  OUT TABLE OutputTable (corr_output_2)
  USING
  TargetColumnPairs ('[2:3]', 'employed:gdp', 'employed:unemployed', 'employed:armedforces')
) AS dt;

Output

 message                                                                                 
 --------------------------------------------------------------------------------------- 
 Output table is successfully stored in the table specified in OutputTable argument
SELECT * FROM corr_output_2;
corr_item1  corr_item2  value_col
----------- ----------- ------------------
gdpdeflator gdp         1.0
armedforces employed    0.4573073983192444
unemployed  employed    0.5024980902671814
gdp         employed    0.9835516214370728
gdp         gdp         1.0
gdpdeflator gdpdeflator 1.0

Download a zip file of all examples and a SQL script file that creates their input tables.