TD_OneHotEncodingTransform Example | Teradata Vantage - TD_OneHotEncodingTransform Example - Teradata® Database

• InputTable: onehotencoding_input, as in TD_OneHotEncodingFit Example
• FitTable: onehotencodingfit_output, created by TD_OneHotEncodingFit Example

SQL Call

SELECT * FROM TD_OneHotEncodingTransform (
  ON onehotencoding_input AS InputTable PARTITION BY ANY
  ON onehotencodingfit_output AS FitTable DIMENSION
  USING
  IsInputDense ('true')
) AS dt;

Output

 Passenger Survived Pclass Name               Age Sex_male Sex_female Sex_other 
 --------- -------- ------ ------------------ --- -------- ---------- --------- 
         1        0      3 Mr. Owen Harris     22        1          0         0
         4        0      3 Mrs. Jacques Heath  35        0          1         0
         3        1      3 Mrs. Laina          26        0          1         0
         2        1      1 Mrs. John Bradley   38        0          1         0