0 - 2 of 2 tags for alter table;merge;insert select;add column;drop column

Hi Everyone,
 
I have created below merge statement in Teradata, but getting error while trying to execute this script.
 

MERGE INTO  AGG_PART_SALES_TEST_CUBE AS Target_tbl

      USING (SELECT 

a12.ANLST_ID  ANLST_ID,  

        a11.BKLG_MSR_IND  BKLG_MSR_IND, 

To add or drop a column or modify the list of compressed values of an existing table is a quite expensive operation. For a large table it might result in a huge amount of CPU and IO usage and a loooooooong runtime. This blog discusses the pros and cons of the different ways to do it.