CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management
In the ETL process used to populate a data warehouse, which activity is performed in the 'Transform' step?
In the Transform step, extracted data is cleaned and standardised: formats are converted, duplicates removed and business rules applied. Extraction only pulls data from sources, and loading only writes the prepared data into the target warehouse.
- APulling raw records out of source systems
- BConverting formats, removing duplicates and applying business rules to extracted dataCorrect
- CPlacing the final data into the target warehouse tables
- DGranting users access rights to reports
Explanation
ETL means Extract, Transform, Load. Extraction pulls data from sources and loading writes it to the warehouse. Transformation sits between them and cleans, standardises, de-duplicates and applies business rules.
Did you get it right without looking?
One question tells you little. A timed set on Database Management shows your real accuracy, how long you take and where you lose marks.
More Database Management questions
- A fintech firm's DBMS lets the marketing team see only customer names and cities, while hiding PAN and Aadhaar columns stored in the same ba…
- In a bank's database, the customer table has the column AccountNo as its unique identifier, and the loan table has a column AccountNo that m…
- A Mumbai-based fintech firm stores customer PAN and account details in a relational database. To ensure that a data analyst can run reports …
- A fintech firm in Pune executes the following in sequence: INSERT of a new loan record, then SAVEPOINT s1, then UPDATE of the interest rate,…
- A bank's database administrator runs the statement GRANT SELECT ON customer TO audit_team. Which category of SQL sub-language does this stat…
- A DBA ensures that changing the way data files are stored on disk does not require rewriting the application programs that use the data. Thi…