The partition points in Informatica mark the thread boundaries in a pipeline and divide the pipeline into stages. These can be retained or deleted based on the following transformations in the pipeline.
• Source Qualifier and Normalizer Transformation – controls the integration service in Informatica to extract data from source and passes it to the source qualifier and deletion cannot be done for this partition point.
• Rank and Unsorted Aggregator Transformation – ensures that the integration service in Informatica groups rows properly before sending it to the transformation and you can delete the partition points if the pipeline contains only one partition or it passes all rows in a group to a single partition before they enter the transformation.
• Target Instances – controls how the writer passes data to the targets and cannot delete this partition point.
• Multiple Input Group Transformation – ensures that the integration service uses one thread to process each partition at a custom transformation that requires one thread per partition and cannot delete this partition point.
DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.