What is the formal definition of data integration?
Data integration is a set of maturing processes, techniques, and technologies used to extract, restructure, move, and load data in either operational or analytic data stores either in real time or in batch mode.
What are the three issues in the Introduction that are caused by the complexity of simply integrating the Loan Type attribute for commercial loans and retail loans into a common Loan Type field in the data warehouse?
• Issue 1. Matching and confirming the fields to the EDW loan type
• Issue 2. Conforming the types and sizes of the field length
• Issue 3. Conforming different loan types into one field (e.g., ...