Transformation

Transformation jobs use INSERT and MERGE statements, enabling you to insert and update the data in your table. Using a MERGE statement in your jobs provides the additional ability to delete data if specified conditions are met.

In this section, learn how to work with arrays in transformation jobs:

• Flattening Arrays

• Working with Arrays