Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
I have a fact table in a data warehouse. The data in some of columns is from the source data. Some of columns must be calculated based on the columns which have source data. So we have to use UPDATE to assign the calculated values for those columns. If I need to load the data to this table every night, will the UPDATE statement cause any problem? I remember Vertica does not like UPDATE statement. Thanks.