A business requires real-time analytics from its ETL process. What transformation logic should be implemented to minimize latency?

  • Apply compression techniques to reduce data volume
  • Implement change data capture (CDC) for incremental updates
  • Load data into a staging area before processing
  • Use batch processing for periodic updates
To achieve real-time analytics with minimized latency, implementing Change Data Capture (CDC) for incremental updates is a suitable transformation logic. This allows the system to capture and process only the changed data since the last update, reducing processing time.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *