This specific task permits one or more than one shell commands in UNIX or DOS in windows to run during the workflow.
For the purpose of creating indexes after the load process, command tasks at session level can be used. Index creating scripts can be brought in line with the session’s workflow or the post session implementation sequence. Moreover this type of index creation cannot be controlled after the load process at transformation level.
In order to perform session partition one need to configure the session to partition source data and then installing the Informatica server machine in multifold CPU’s.
Partitioning a session means solo implementation sequences within the session. It’s main purpose is to improve server’s operation and efficiency. Other transformations including extractions and other outputs of single partitions are carried out in parallel.