Explain source-to-target mapping.
💡 Model Answer
Source-to-target mapping is a core concept in ETL (Extract, Transform, Load) processes where data from a source system is transformed and loaded into a target system. The mapping defines how each source field corresponds to a target field, including data type conversions, transformations, and business rules. A typical mapping document contains:
Mapping can be manual or generated by tools like Informatica, Talend, or custom scripts. It ensures data consistency, quality, and traceability. During development, mapping is validated by unit tests and data profiling. In production, mapping changes are versioned and deployed through CI/CD pipelines to avoid data drift. Proper source-to-target mapping reduces ETL errors, improves maintainability, and provides a clear audit trail for compliance and troubleshooting.
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