This option enables you to force the use of table target locations (defined in the Connection Properties > Target Settings), and prevents the use of legacy local targets when creating new table objects in RED. 
This option is enabled by default for new repositories—it is recommended to define targets for the data warehouse objects that is separate from the metadata database.

The Force Target Usage setting removes the option to use local targets in the Default Target drop-down list of the Target Location option and also hides the Table Storage option, which is used to set the storage locations for each table object type created in RED.

  • Existing RED objects or objects loaded into RED with local set as their target, retains the local target setting.
  • If the target location is changed from local to a specific target, then there is no option to set it back to local without deactivating the Force Target Usage setting.
  • If table target(s) has not been defined, a message is displayed to warn users that this setting does not take effect, until a target is created.

To see more about creating target locations, Refer to Connection to the Data Warehouse for details.