A data analyst is tasked with migrating customer information from a legacy sales application to a new data warehouse. The process involves pulling the raw data, standardizing date formats, and then pushing the cleaned data into the final tables. Which of the following data integration methods is being used?
ETL stands for Extract, Transform, Load. This method involves retrieving data (extract), making necessary changes (transform), and loading it into a final destination (load). Delta load gathers updated records instead of the initial dataset. API data retrieval refers to fetching details through an interface and does not typically include transformations or loading. Data profiling inspects data conditions without shifting it to a different location.
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.