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
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
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".

No comments:

Post a Comment

Popular Posts