In scenarios requiring data from multiple sources, the ________ transformation is used to combine these sources effectively.

  • Aggregate
  • Combine
  • Join
  • Merge
The "Join" transformation is utilized in ETL processes to effectively combine data from multiple sources. It helps in integrating information from diverse origins to create a unified dataset.
Add your answer
Loading...

Leave a comment

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