From headquarters issued to the branch in TXT text format, with tens of thousands of article, probably with importfile imported into the dw, division database has some data has, however, if the use cycle, one at a judge whether the database has duplicate records, the efficiency is too low, is there a better way,

CodePudding user response:

To the temporary table first, and then the background processing.

CodePudding user response:

How to deposited in the temporary table, all are dynamic

CodePudding user response:

refer to the second floor zsyutiannew response:

how deposited in the temporary table, the whole is dynamic

To build an intermediate table, according to the intermediate table do a DW, the text import to DW, save, and then the background is more needed data, again after the completion of empty table in the middle