Building the first transformation

To create a new Transformation:

  1. Select File > New > Transformation
    Alternativity, click the + icon and click Transformation.
  2. On your first transformation you must select a target database for your staging / transformation. If you want only an output file, then this is not required.
  3. Click the View tab and right-click Database connections.
  4. Specify the preferred target connection and name it for example staging.
  5. Click Test to test the transformation.
  6. To close the dialog box, click OK.