Archives of the TeradataForum
Message Posted: Mon, 19 Mar 2013 @ 01:36:09 GMT
| Subj: || || Re: MERGE question |
| From: || || robertmierzwinski |
Just a word of caution with merge...we have a Cdc application using merge update when matched that logically deletebs a row by updating an
enddate columnfrom 9999-12-31 to current cycle date. - 1.
Update works fine but the table has potential tobecome very large with a potential ppi tobe built over the enddate with a separate partition on
value of 9999-12-31 the merge prohibits update of columns which participatein a Pi or ppi