You need to integrate customer data stored in separate marketing, sales, and support databases. These sources use varying formats and field names for similar attributes like customer name and contact information. What strategy will you use to create a unified dataset that eliminates inconsistencies and ensures accuracy across all sources?
Develop a central framework with consistent attributes and map all source data to align with this structure
Secure sensitive data by anonymizing selected fields
Reformat individual fields without reconciling their differences
Remove records that lack required fields or contain errors
Merging and harmonizing data from multiple sources into a standardized framework ensures consistency and dependability. Strategies that involve masking sensitive information or discarding incomplete rows address specific issues but do not establish a consistent data structure.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is meant by creating a 'central framework' for data integration?
Open an interactive chat with Bash
How do I ensure accuracy when mapping data from different sources?
Open an interactive chat with Bash
What challenges might arise when integrating data from multiple databases?