Question: 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.

Question: What are the benefits of a session partitioning?

Partitioning or splitting is referred as running a single implementation sequence within the session. Its main purpose is to improve server operation and efficiency. Other transformations, including extraction of individual partitions and other outputs, are performed in parallel.

Question: What is DTM (Data transformation manager) Process in Informatica Power Centre?

The Informatica PowerCenter Integration Service (PCIS) started an operating system process called the Data Transformation Manager (DTM) process to run the session. Its main task is to create and manage threads responsible for executing session tasks. DTM tasks include:

Read the session information

Form dynamic partitions

Send post-session email

Validate code

Run the processing threads

Create partition groups

Run post-session operations

Question: What is incremental loading in Informatica PowerCenter?

Incremental data loading is the process of selectively loading updated or newly created data from a source system to a target system.

Incremental loading Benefit.

Processing of selected data from source systems reduces overhead in the ETL process and reduces overall execution time.

ETL loads are prone to errors and failures for many reasons. Potential risks are reduced as only selected data is processed.

Historical Data accuracy is maintained. This makes it easy to track data processed over time.

Question: Explain complex mapping in informatica and explain its features?

A mapping is considered complex if it contains many requirements based on too many dependencies. Mapping can be complex even with just a few transformations. No need for hundreds of conversions. Mapping becomes complicated when requirements have many business requirements and constraints. Complex mappings also include slowly varying dimensions.

A complex mapping consists of three functions:

Large and complex business requirements

Complex business logic implementation

Multiple Transformations 

Question: Where can I find throughput options in Informatica?

The throughput option is in Informatica's Workflow Monitor. Right-click the session in the Workflow Monitor and click Get Run Properties. Under "Source/Destination Statistics" there is a "Throughput" option.

Question: How can previous session logs is stored in Informatica PowerCenter?

When you run a session in timestamp mode, automatic session logout does not overwrite the current session log.

To achieve it follow the below mentioned step.

Visit Session Properties –> Configuration Objects –> Log Options.

Select properties as follows:

Save session log –> SessionRuns

Save session logs for these runs –> Change the number of log files to save (default is 0).

If you want to save all log files created during each run of job, select the save session logs for these runs -> click session timestamp option.

These properties are in the session/workflow properties.