sql - Updating tables in greenplum databse using gpload -

i having local table xyz in greenplum. populating table data 5 other tables ( table xyz has few columns , data 5 different tables, populated join operation ).

this working fine. problem facing here are:

1> need table xyz have recent data. if new entry comes in 5 tables ( xyz being populated ), table xyz should updated.

2> if existing record gets modified in case data in table xyz should modified. have 1 more table history_of_xyz, table contains data ( history ) of xyz. example : lets 1 entry customer abc living in usa. abc has moved new country lets russia. history table have data corresponding entry usa , table xyz have recent updated data customer living in russia.

so not able figure out best way approach step 1 , 2.

how can done considering data in greenplum database.

i did research on gpload , other loading options not sure how approach step 1 , 2.

any pointers helpful. pretty new db. setting table structure , populating table big learning curve me.

i guess need @ interactive ingesting tools spring xd, see topic streams.

regards, moha.