Target Load Order/ Target Load Plan in Informatica

  • Updated
  • Posted in Programming
  • 2 mins read


Target Load Order:

Target load order (or) Target load plan is used to specify the order in which the combination service hundreds the targets. You can specify a goal load order primarily based on the supply qualifier transformations in a mapping. If you’ve a number of supply qualifier transformations related to a number of targets, you may specify the order in which the combination service hundreds the information into the targets.

Target Load Order Group:

A goal load order group is the gathering of supply qualifiers, transformations and targets linked in a mapping. The integration service reads the goal load order group concurrently and it processes the goal load order group sequentially. The following determine reveals the 2 goal load order teams in a single mapping:

Use of Target Load Order:

Target load order will probably be helpful when the information of 1 goal will depend on the information of one other goal. For instance, the staff desk information will depend on the departments information due to the primary-key and foreign-key relationship. So, the departments desk needs to be loaded first after which the staff desk. Target load order is helpful whenever you need to keep referential integrity when inserting, deleting or updating tables which have the first key and overseas key constraints.

Target Load Order Setting:

You can set the goal load order or plan in the mapping designer. Follow the beneath steps to configure the goal load order:

1. Login to the powercenter designer and create a mapping that comprises a number of goal load order teams.
2. Click on the Mappings in the toolbar after which on Target Load Plan. The following dialog field will pop up itemizing all of the supply qualifier transformations in the mapping and the targets that obtain information from every supply qualifier.

3. Select a supply qualifier from the checklist.
4. Click the Up and Down buttons to maneuver the supply qualifier throughout the load order.
5. Repeat steps 3 and 4 for different supply qualifiers you need to reorder.
6. Click OK.

Leave a Reply