From the course: CompTIA Data Systems (DS0-001) Cert Prep

Unlock this course with a free trial

Join today to access over 24,200 courses taught by industry experts.

Data mapping

Data mapping

From the course: CompTIA Data Systems (DS0-001) Cert Prep

Start my 1-month free trial Buy for my team

Data mapping

“

- As you conclude functional and performance testing, validating the database configuration is essential to ensure operational stability. Data mapping is one of the important activities that you should undertake during your database validation process. Data mapping ensures that data elements consistently map to similar data types as data flows between the database and the systems that it interacts with. Databases are both sources of and destinations for data, and no database exists in isolation. It's essential to map data correctly when you're integrating multiple systems. Data mapping is also vital when you're migrating data from an existing database to a new one. For example, suppose you have an address table that stores postal codes as numeric data types. If you discover addresses from a legacy system have alphanumeric postal codes, validating that mapping of postal codes would cause you to change the data type of the postal code column from numeric to alphanumeric. By…

Contents