EVENT WAIT AND EVENT –RISE:
- Create a work flow with the name w-event-wait-raise
- Go to task menu click on create
- Select the task type as event wait, enter the name event-source click-create
- Drag the session s10, s20, s30 to the workflow design
- Double click on the event wait
- Click on events tab
- Please event the name of the file to watch D:/path/filename.txt click on ok
Event rise task:
The integration service rises the ‘user defined events ‘during the work flow run
The user-defined events declared in work flow properties event tab.
- The event rise task are always used in conjunction with event wait task
- The event raise task sends a signal to the event wait task that a particular set of predetermined event has occurred
- A user-defined event is defined completion of tasks from start task to event raise task
Event wait task:
An event wait task waits for a specific event to occur to start the next task in the work flow
- Pauses the processing of the pipeline until a specified event occurs
- There are two types of events can be defined
- File watch event (predefined event)
- User-defined event
Procedure:
- From tools, menu selects workflow designer
- From the workflow menu select create ]
- Enter the workflow name w-star-load
- Selects the event tab
- From tools, bar click on new
- Enter the event name dim- load – complete, click ok
- Drop the sessions beside the workflow
- From the workflow designer select task, select event raise and event wait
- Create the task type event raise and event wait
Link tasks as described in work flow Diagram.
Double click on event raise task, select properties tab
Attribute | Value |
User defined event | Dim-load-complete |
From work flow designer select task, select command and event wait.
Double click on command task and select command tab
From tool bar click on add a new command.
Name | Command |
Success | Copy e:/result.txt to c:/ batch 4pm |
Click on apply and click ok
Double click on event wait task selects the event tab.
Select the predefined event
Enter the name of the file to watch
C:batch 4pm result.txt
Click on apply and click on ok.
Assignment task:
It allows you to assign the values (or) expressions to the user-defined workflow variables
The user-defined workflow variables are declared in a work flow properties variable tab.
Decision task:
The decision task allows you to define the condition and the condition is evaluated by integration service, returns true (or) false.
The decision task as a predefined condition variable called $decision-task-name. Condition, which is assigned with results of decision condition
- Use the task instead of using multiple link condition
Procedure:
- From tools menu, selects workflow designer, from the work flow menu select create
- Enter the work flow name w-daily-weekly-wad
- Select the variable tab from tool bar click on add a new variable
Name | Data type | Presentence |
$$wkf-runs | Integer |
Enter the default value =0
Bellow
Click ok
- Drop the session beside the work flow
- Create the task type assignment and decision
- make a links between the task as described above
- define the link condition between the S10 and assignment task $S10.status =succeeded
- double click on assignment task, select the expression tab
- from tool bar click on add a new expression
USER DEFINED VARIABLE | OPERATOR | EXPRESSION |
$$WKF-runs | = | $$wkf-RUNS+ |
Click on apply and click ok
Define the link condition between assignment and decision
$assign. Status=succeeded
Double click on decision task select the properties tab
If you want to enrich your career and become a professional in Informatica, then visit Tekslate - a global online training platform: "Informatica Training" This course will help you to achieve excellence in this domain.
Attribute | Value |
Decision name | MOD ($$WHF-runs, 7 )=0 |
Click on apply and click ok
Define the link condition between the decision and S20
$Decision. Condition=true
To view the presentence value right-click on work flow select
For in-depth understanding of Informatica, click on
- Rank Transformation in Informatica
- Aggregator Transformation in Informatica
- Expression Transformation in Informatica
- Lookup Transformation in Informatica
- ETL Project Architecture
- Interview Questions