#176. Examine the structures of the AR_TRX and AR_TRX_HY tables. You are loading historical accounts receivable data from the AR_TRX table into the AR_TRX_HY table. During the load, you want to transform the data so that the GRAND_TOTAL column of the AR_TRX_HY table is equal to the sum of the EXT_AMT and TAX_AMT columns in the AR_TRX table. You want to set LOAD_DATE to the current date. If the record already exists in the target table, all values, except TRX_ID and TRX_TYPE, should be refreshed with the most recent data. Which MERGE statement should you execute?
gen. 0.042
Forum
Master braindump