Question

What are the different types of methods for the implementation of parallel processing in Informatica?

Answer 1

There are different types of algorithms that can be used to implement parallel processing. These are as follows:

1. Database Partitioning - Database partitioning is actually a type of table partitioning information. There is a particular type of service that queries the database system or the information of the database, named the Integration Service. Basically, it looks up the partitioned data from the nodes of the database.
2. Round-Robin Partitioning - With the aid of this, the Integration service does the distribution of data across all partitions evenly. It also helps in grouping data in a correct way.
3. Hash Auto-keys partitioning - The hash auto keys partition is used by the power center server to group data rows across partitions. These grouped ports are used as a compound partition by the Integration Service. 
4. Hash User-Keys Partitioning - This type of partitioning is the same as auto keys partitioning but here rows of data are grouped on the basis of a user-defined or a user-friendly partition key. The ports can be chosen individually that correctly defines the key. 
5. Key Range Partitioning - More than one type of port can be used to form a compound partition key for a specific source with its aid, the key range partitioning. Each partition consists of different ranges and data is passed based on the mentioned and specified range by the Integration Service. 
6. Pass-through Partitioning - Here, the data are passed from one partition point to another. There is no distribution of data.