Multiple source system data has 10 million, only to guide the 99.5 million, how do I find 500000?

CodePudding user response:

How do you find less 500000 is what?
What do you mean to find less 50 data?

CodePudding user response:

Yes, how to find less 500000 data

CodePudding user response:

Prior:
1. Increase the migration log, source, should be exported, the actual export...
2. Target table, increase the source data identification, from which the library

After the event:
Find can identify the source of characteristic data, one by one, miserable,

CodePudding user response:

Ods layer best design like this: assuming that multiple source systems 10 tables of data needs to be imported into the ods layer, layer on ods built 10 form table one-to-one correspondence with the source system, ods data table data is highly consistent with the source system, where a few according to be clear at a glance

CodePudding user response:

Both sides had better have the same primary key values, such a contrast to check the reason, because a few according to see if the conditional filtered out,