An update is a data manipulation language, or DML operator. Updating a PI column causes performance degradation:
UPDATE table_name SET col_name=expression [, ..., col_name=expression] [ALL | WHERE condition];
For this recipe to complete, you need to connect to the Teradata instance and open SQLA.
- Identify the target table that needs to be updated.
- Identify the source table from which the update is to be done:
update test01.web_clicks a -- Target update table from test02.wed_address b -- Source update table set acc_last_date= date -- Target column that's need to updated where a.Rego_Start_Dt between '2016-12-25' and '2017-01-28' -- Partition column