What are different types of tasks available in informatica Power Centre?

Assignment Task: Value is assigned to a workflow variable by Assignment task type.

Command Task: It executes a shell command during the time of workflow execution.

Control Task: Control task cease or aborts workflow execution.

Decision Task: It tells a condition to be evaluated during the session.

Email Task: This is used during workflow execution to send emails.

Event-Raise Task: Event-Raise task updates Event-Wait about the happening of an event.

Event-Wait Task: Event-Wait task waits for an event to complete before executing the next task in informatica power centre.

Session Tasks: These tasks are used to run mappings created in Designer. User can create a session for each mapping that user wants the Integration Service to run.

Timer Task: Timer task waits for an already timed event to occur. User can specify the time in the timer task to wait before the process triggers the next task in the workflow.

How to generate sequence numbers/ incremental numbers using expression transformation in Informatica Power Center while doing mapping?

Method 1.

 In the expression transformation, create a variable port(V_count) and increment it by 1. Then assign the variable port to an output port(O_count).

In the expression transformation, the ports are:

V_count = V_count+1

O_count = V_count

Method 2.

Choose sequence generator transformation and connect NEXTVAL port of sequence generator to expression. This port will provide the incremental value to expression as input.

Also choose start value =1 and incremented by 1 to get numeric series of 1,2,3….