Hands on 03_Creating_Workflow:-
The exercises in this lab familiarize the student with the process
of creating a simple workflow with a start task and session task. This workflow
will essentially define a run-time version of the mapping created in the previous lab.
The exercises will also familiarize the student with the process of starting and
monitoring a workflow.
Objectives:
After completing the lab,students will be able to:
- Use the Workflow Manager
- Create a new workflow.
- Create and edit session tasks.
- Link tasks within a workflow.
- Validate a Workflow
- .Start a workflow.
- Use the Workflow Monitor to monitor a workflow.
- View session information and the session log after
a workflow has run.
Exercises:
8.1 Exercise 1: Create a Workflow
In this exercise,Students will create a new Workflow
Step 1. Start the Workflow Manager:
- Select Start ->Programs -> Informatica 9.0.1 -> Client -> Power Center Client-> Power Center Workflow Manager
- Click on OK
Step 2. Connect to the Repository:
6. Select the RRITEC_REP repository.
7. Right Click on Repository RRITEC_REP | Connect
8. The Connect to Repository dialog box appears
7. Right Click on Repository RRITEC_REP | Connect
8. The Connect to Repository dialog box appears
9. Enter the username and password--
username: Administrator
password: Administrator
10. Click the Connect button.
11. Right-click on the RRITEC folder and select Open.
12. Open the Workflow Designer by selecting Tools | Workflow Designer or click
username: Administrator
password: Administrator
10. Click the Connect button.
11. Right-click on the RRITEC folder and select Open.
12. Open the Workflow Designer by selecting Tools | Workflow Designer or click
the Workflow Designer button above the workspace
Step 3. Set the default target load type:
1. Select Tools | Options, Miscellaneous tab, and set the default target
load type for all sessions to Normal.
load type for all sessions to Normal.
2. Click OK.
Step 4. Create a new Workflow:
1. Select Workflows | Create.
2. The Create Workflow dialog box appears
2. The Create Workflow dialog box appears
3. On the General tab, enter wf_ODS_EMPLOYEE in the Name field
4. Click OK.
5. The Start task appears in the Workflow Designer workspace:
5. The Start task appears in the Workflow Designer workspace:
6. Save the repository
8.2 Exercise 2: Create Source and Target Database Connections
Creating Source Connection :
1. Go to Connection menu -> Click on Relational -> Click on
new ->Select Oracle ->click on OK ->
o Name : Native_source
o Username : sdbu
o Password :Rritec123
o Connect String : ORCL
o Username : sdbu
o Password :Rritec123
o Connect String : ORCL
2. Click on OK -> Click on Close
Creating Target Connection :
1. Go to Connection menu -> Click on Relational -> Click on new
->Select Oracle ->Click on OK ->
o Name : Native_target
o Username : tdbu
o Password :Rritec123
o Connect String : ORCL
o Username : tdbu
o Password :Rritec123
o Connect String : ORCL
2. Click on ok -> Click on Close
8.3 Exercise 3: Create a Task and Run the Workflow
In this exercise,Students will create a Session task
Step 1. Create a Session task:
- Note that each session task is associated with a single mapping. Click on the Session button on the Task toolbar.
This appears by default at the top right of the Designer window and
may be part hidden. Click on the vertical bar at the left of the toolbar
to drag it to another position.
2. Move the pointer into the workspace and Click ->
The Mappings dialog box appears -> Select the mapping
m_ODS_EMPLOYEE -> Click OK.
3. The session task s_m_ODS_EMPLOYEE appears in the workspace.
4. Save the repository.
3. The session task s_m_ODS_EMPLOYEE appears in the workspace.
4. Save the repository.
- Note : We can also create using navigation Tasks ->Create ->provide name
-> Click OK
Step 2. Edit the Session task’s properties:
1. Double-click on the s_m_ODS_EMPLOYEE Session task. Then
Edit Tasks dialog appears -> Select the Properties tab
2. Note that the default Session Log File Name, s_m_ODS_EMPLOYEE.log,
and the default Session Log File directory, $PMSessionLogDir, may be
overridden, but we will use the defaults for this lab.
3. Select the Mapping tab.
4. In the Navigator window, select the source sq_EMPLOYEE.
In the Connections section, click on the down arrow , select native_source
and click OK.
overridden, but we will use the defaults for this lab.
3. Select the Mapping tab.
4. In the Navigator window, select the source sq_EMPLOYEE.
In the Connections section, click on the down arrow , select native_source
and click OK.
.
5. In the Navigator window, select the target ODS_EMPLOYEE.
6. In the Connections section, click on the down arrow , select
6. In the Connections section, click on the down arrow , select
native_target and click OK.
7. In the Properties section, the Target load type should be defaulted to Normal.
8. Scroll down (if necessary) and check the Truncate target table option
check box.
7. In the Properties section, the Target load type should be defaulted to Normal.
8. Scroll down (if necessary) and check the Truncate target table option
check box.
9. Click OK to close the Edit Tasks dialog box.
10. Save the Repository
10. Save the Repository
Step 3. Link the Workflow tasks:
1. Click the Link button on the Task toolbar.
2. Left-click and drag the cursor between the Start task and the
s_m_ODS_EMPLOYEE task:
2. Left-click and drag the cursor between the Start task and the
s_m_ODS_EMPLOYEE task:
3. Toggle off the ‘link mode’ by clicking again on the Link button, or
single click on one of the objects.
Step 4. Validate the workflow:
1. In order for a workflow to be valid, all tasks must be linked.
Save the repository.
2. Locate the Save tab in the Output Window at the bottom of the
2. Locate the Save tab in the Output Window at the bottom of the
Workflow Manager and view the results of the validation check:
Step 5. Start the Workflow:
1. Select Workflows | Start workflow, or right-click in the workspace and
select Start Workflow.
2. The Workflow Manager dialog box appears:
2. The Workflow Manager dialog box appears:
8.4 Exercise 4: Monitor the Workflow
Step 1. Navigate in Workflow Monitor:
1. A workflow will show a Succeeded status if it starts up and complete
successfully, in and of itself. There may be several tasks within the
workflow and each will succeed or fail but the workflow itself will can
complete successfully. One of the only reason to workflow will fail,that is
when the Server cannot write the workflow log. The Workflow Monitor
window opens automatically when a workflow is started and automatically
logs into the repository, displaying the workflow status.
2. The Workflow Monitor has two tabs – Gant Chart and Task View.
Look at the Task View.
3. Notice the two objects:
wf_ODS_EMPLOYEE (workflow)
s_m_ODS_EMPLOYEE (session task)
4. The Status column shows the session status:
- Succeeded indicates that the Informatica Server was able to successfully complete a workflow or task.
- Failed indicates that the Informatica Server could not complete the workflow or task due to a fatal processing error.
Step 2. View the Session properties:
1. Session properties provide detailed information about processing,
such as the number of rows loaded into the target by a session task.
Locate the s_m_ODS_EMPLOYEE session task under the Workflow
Run column
2. Right click on s_m_ODS_EMPLOYEE session -> Click on get run
properties -> Observe source success rows and target success rows.
2. Right click on s_m_ODS_EMPLOYEE session -> Click on get run
properties -> Observe source success rows and target success rows.
Step 4. View the Session log:
1. Right-click on the session in the Task Name column (Time window)
and select Get Session Log, or by clicking on the Session Log button.
2. The session log is displayed:
2. The session log is displayed:
No comments:
Post a Comment