Execution Mode Selection for FTP Propagation
A new Execution Mode option is now available for FTP Propagation and Advanced FTP Propagation components. Users can choose from the following modes:
- Single Query Approach: Suitable for small or medium-sized datasets (less than 500,000 records). This mode offers faster execution with minimal overhead and is ideal for manageable data volumes.
- Sliced Queries Approach: Recommended for large datasets (500,000 records or more) that may impact performance or memory usage when processed in a single query. This mode divides the dataset into smaller slices, improving query performance and reducing processing time.
Business Benefit:
Enhances performance and scalability by allowing users to select an execution mode that best fits their data size and system capacity.
Steps to Enable
You don't need to do anything to enable this feature.