I built a database, there are three customer information tables, now don't know how to get into the data warehouse, don't know what kind of tools, and how to operate, can have a great god help me can add QQ335048700 teach me ~ please

CodePudding user response:

Can't see figure, also don't know what floor;

CodePudding user response:

Don't know the captions of the data warehouse is how to understand and advice to see Bill Inmon's book, I'll give you an the characteristics of the data warehouse, integration: as rodrigo says three customer table, if A company has three sets of systems, each system has the customer information table A, B, C, and record the different themes, A table of customer code is 001002,,,, so, said B table customer code is 1, 2,,,, in this way, the C client code is W1, W2,,,, then you put the three tables is drawn to your data warehouse, the customer must be unified into A kind of coding, which is one of the direction, as for the extraction tool will have A lot of, specific baidu can be found