Change Collation for a Wave

Decide whether the data being processed in a wave should be treated as being case insensitive or case sensitive. By default, new waves are collation insensitive. However, users may change the collation type for the data source and link to reports of table columns and the database that have a collation mismatch and fix it.

NOTE: Only users assigned to the System Administrator or the Migration Developer Advanced security roles can change the collation for the wave. Refer to Delivered Security Roles in System Administration for more information.

To change collation for a wave:

  1. Select Advanced Data Migration in the Navigation pane, or select Console in the Context bar.

  2. Click Waves in the Navigation pane.

  3. Click Vertical View for the wave.

  4. Click the Toggle Collation icon; a warning message displays to confirm the wave collation is about to be changed.

NOTE: An error displays if

  • the data source being used in the wave has a different collation than the attempted new collation setting for the data source.

  • any assigned data source has a different Collation Type than the wave.

  1. Click OK; the Collation Type field is updated with the new collation.