HomeInterview QuestionsEtl, Data Transformation, Data Engineering

You think those are transformations? And how would you justify your answer there?

🟢 Easy Conceptual Fresher level
1 Times asked
Aug 2026 Last seen
Aug 2026 First seen

💡 Model Answer

In an ETL pipeline, a transformation is any operation that changes the data’s structure, format, or content before it is loaded into the target system. Common examples include filtering rows, aggregating values, joining tables, converting data types, or deriving new columns. To justify that a step is a transformation, you can ask:

If the answer is yes to these questions, the step qualifies as a transformation. For instance, converting a string date to a timestamp or calculating a total sales column from individual line items are classic transformations because they alter the data’s form or add derived information before it is stored.

Sign in to unlock the rest of this answer

This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.

🎤 Get questions like this answered in real-time

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.

Get Assisting AI — Starts at ₹500