Configuring Performance Parameters

This option allows you to externalize performance parameters like Source Hint, Source Prescript, Target Hint and Target Prescript for OOB metadata definition.

• For T2T- Source Hint, Source Prescript, Target Hint, and Target Prescript are applicable.
• For T2F - Source Hint and Source Prescript are applicable.
• For F2T - Nothing is supported.

To configure Performance Parameters:

1. From the Optimizations tab in the DMT Configurations window, select the required Data Mapping definition for which you want to configure performance parameters and click Edit. The Performance Parameters window is displayed.

   Figure 7-35 Performance Parameters

   
   

   

   
   
2. Specify Source Prescript or Target Prescript if you want to use it. Prescripts are supported for all HIVE based target Infodoms, that is, H2H and T2H. In case of H2T, the prescripts are fired on the source.
   For more information, see Prescripts.
3. Specify Source Hint and Target Hint (if any), for faster loading. Oracle hints follow (/*+ HINT */) format.
   The mapping level hint is applicable for T2T, H2T, and H2H only.
   For example, /*+ PARALLEL */.
4. Click Save.