CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management
In the ETL process used to populate a data warehouse, a bank standardises date formats, removes duplicate customer records and converts all currency amounts to rupees before loading. Which ETL stage does this activity belong to?
This activity belongs to the transformation stage of ETL. Cleaning duplicates, standardising date formats and converting currencies are all steps that reshape extracted data into a consistent form before it is loaded into the data warehouse.
- AExtraction
- BTransformationCorrect
- CLoading
- DArchiving
Explanation
Transformation is the stage where extracted data is cleaned, deduplicated, standardised and converted into a consistent format. Extraction only pulls data from the source systems. Loading writes the already prepared data into the warehouse.
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 telecom company handles huge call-record streams arriving at high speed, in text, audio and log formats, from many sources. Which set of c…
- A firm's database administrator runs a DELETE statement without a WHERE clause inside a transaction that has not been committed, then realis…
- A web application builds its SQL query by directly joining text typed by a user into the query string. An attacker enters input that alters …
- A fintech company mines its big-data store of customer records to profile individual behaviour and sells the profiles to advertisers. The re…
- In an ER design for a listed company's compliance system, 'Dependent' (family members of an employee) has no key of its own and is identifie…
- In an Employee table, Emp_ID is the primary key, and columns are Dept_ID and Dept_Head, where Dept_ID determines Dept_Head. A company wants …