Building and Running Single-Source and Multi-Source Execution Plans

Building and Running Single-Source and Multi-Source Execution Plans

Before you attempt to run an execution plan, make sure you have completed the following:

1)   Set database connections to the transactional and data warehouse databases (in the Physical Data Sources tab).

2)    Registered the Informatica PowerCenter Services and Integration Service (in the Informatica Servers tab).

3)   Before you attempt to run a multi-source execution plan, you must first define the priority for each source.

4)   The priority specifies the order in which DAC will load the data from the  different sources.

5)    For more information about the source priority property, see "Physical Data Sources Tab".

To define a source priority

1. Navigate to the Setup view, and then select the Physical Data Sources tab.

2. For each of the physical data sources that will participate in the multi-source execution plan, enter a numerical value in the Priority field.

The lower the numerical value, the higher the priority. For example, if you enter a

value of 1, data from this source will be loaded first.

To build and run a single-source or multi-source execution plan

1. Navigate to the Execute view, then select the Execution Plans tab.

2. Create a new execution plan.

a. In the top pane toolbar, click New.

b. In the top pane window or in the Edit subtab, enter a name for the execution

plan and other appropriate information.

For a description of the fields in this tab, see "Execution Plans Tab".

c. Click Save.

3. Associate one or more subject areas with the execution plan.

a. Click the Subject Areas child tab.

b. Click Add/Remove in the bottom pane toolbar.

c. In the Choose Subject Areas dialog, select the appropriate source system

container from the drop-down list.

d. Query for the subject area you want to associate with the execution plan.

e. Select the subject area and click Add.

You can repeat this process to associate multiple subject areas from any

available source system container with an execution plan.

f. Click OK to close the window.

4. Generate the runtime execution plan parameters.

a. Click the Parameters subtab, and then click Generate in the bottom pane

toolbar.

b. In the Generating Parameters dialog box, enter the number of copies for each

source system container, and then click OK.

c. Click OK in the informational message.

DAC automatically generates the parameters required for each copy. Not all

copies require all of the possible parameters.

d. On the Parameters subtab, edit the parameters for each copy of the source

system container as follows:

For each data source type, select the appropriate value from the Value

drop-down list.

Note: For the data source type of FlatFileConnection, make sure you

have copied all files into the directory specified in the DAC system

property InformaticaParameterFileLocation.

For each Informatica SIL and SDE folder, select the appropriate value in the

Value drop-down list.

e. For each data source type, enter the appropriate name in the Value field.

f. (Optional) If you are extracting data from more than one source system

container and want to stagger the data extracts, in the Delay field for the

appropriate data source, enter a value for the number of minutes you want to

delay the extract.

5. Click the Ordered Tasks child tab and verify the following:

a. Click Details in the toolbar, and review each task’s predecessor and successor

tasks to confirm tasks common to multiple sources are ordered in a manner

consistent with the priority of the source connection.

b. Confirm that load tasks appear only once even if there are multiple extracts for

tables common to multiple sources.

c. For tasks common to multiple sources, click Preview Run Details in the

toolbar, and confirm the following:

The first common task truncates the common target table and the following

tasks do not.

The first common task truncates the common target table and the following

tasks do not.

For instructions on unit testing a task, see "Unit Testing Execution Plan Tasks".

6. In the top pane of the Execution Plans tab, make sure the new execution plan is

highlighted, and click Build.

7. In the Building... dialog box, select the option Selected Record Only, to build only

the selected execution plan.

8. To run the execution plan, select the execution plan in the top pane, and click Run

Now.

Once the ETL process starts running you can monitor its progress in the Current

Run tab.

For information about how refresh dates are tracked, see "About Refresh Dates".

To schedule an execution plan, see "Scheduling an Execution Plan".