Hi all,
I'm wanting to insert several rows into T_POTENTIAL_DUPS based on some customized criteria that the procedure AP_IDENTIFY_DUPES doesn’t pick up.
What is the best way to generate the 'criteria' column? On custom merges, is usually looks like this: !@#$CUSTOM7969 and I can’t find where and how this is generated.
Last time in inserted a large number of rows into a column using a loop I didn’t know about T_NEXT_ID and so temporarily ‘broke’ the table. I want to check this time!
Thanks for any advice,
Tash
Hi Tash,
Please find my procedure lp_chc_const_dups_POTENTIAL which uploads potential dups from custom table C_CHC_CONST_DUPS (populated by my proc. lp_chc_const_dups_PREP) to T_POTENTIAL_DUPS. It creates a custom values for column "criterion" . Please note that this procedure is used in our custom process of a bulk de-duping which we run once a year. If interested I'll provide more details.
Thanks,
Simon Basyuk, DBA of Carnegie Hall
sbasyuk@carnegiehall.org
Thanks folks, this is all extremely helpful. Cheers!