TD_ScaleFit Syntax | ScaleFit | Teradata Vantage - TD_ScaleFit Syntax - 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

TD_ScaleFit Syntax without Partition

TD_ScaleFit (
ON { table | view | (query) } AS InputTable
[ OUT [ PERMANENT | VOLATILE ] TABLE OutputTable(output_table_name) ]
USING
ScaleMethod ({'MEAN' | 'SUM' | 'USTD' | 'STD' | 'RANGE' | 'MIDRANGE' | 'MAXABS' | 'RESCALE({lb=lower_bound | ub=upper_bound | lb=lower_bound,ub=upper_bound})'} [,...])
[ MissValue ({ 'KEEP' | 'ZERO' | 'LOCATION' }) ]
[ GlobalScale ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
[ Multiplier ('multiplier' [,...]) ]
[ Intercept ('intercept' [,...]) ]
[ IgnoreInvalidLocationScale ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
{ for_dense_input | for_sparse_input }
)
for_dense_input
TargetColumns ( { 'target_column' | 'target_column_range' } [,...] )
for_sparse_input
AttributeNameColumn ('attribute_name_column')
AttributeValueColumn ('attribute_value_column')
[ TargetAttributes ('target_attribute' [,...]) ]

TD_ScaleFit Syntax with Partition

TD_ScaleFit (
ON { table | view | (query) } AS InputTable PARTITION BY partition_column [,...]
[ ON { table | view | (query) } AS ParameterTable PARTITION BY partition_column [,...] ]
[ ON { table | view | (query) } AS AttributeTable PARTITION BY partition_column [,...] ]
[ OUT [ PERMANENT | VOLATILE ] TABLE OutputTable(output_table_name) ]
USING
ScaleMethod ({'MEAN' | 'SUM' | 'USTD' | 'STD' | 'RANGE' | 'MIDRANGE' | 'MAXABS' | 'RESCALE({lb=lower_bound | ub=upper_bound | lb=lower_bound,ub=upper_bound})'} [,...])
[ PartitionColumns ('partition_column' [,...]) ]
[ MissValue ({ 'KEEP' | 'ZERO' | 'LOCATION' }) ]
[ GlobalScale ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
[ Multiplier ('multiplier' [,...]) ]
[ Intercept ('intercept' [,...]) ]
[ IgnoreInvalidLocationScale ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
{ for_dense_input | for_sparse_input }
)
for_dense_input
TargetColumns ( { 'target_column' | 'target_column_range' } [,...] )
[ UnusedAttributes ({'UNSCALED' | 'NULLIFY'}) ]
for_sparse_input
AttributeNameColumn ('attribute_name_column')
AttributeValueColumn ('attribute_value_column')
[ TargetAttributes ('target_attribute' [,...]) ]
You can call this function from:
  • The FROM clause of a SELECT statement
  • As part of a CREATE TABLE statement
  • As part of a CREATE VIEW statement