Event Wait and Event Rise in Informatica

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

Checkout: (Informatica Components)

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

1. File watch event (predefined event)
2. 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

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

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.

Checkout: [Variable Ports in Informatica]

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

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

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.

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