Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

Full Pushdown Optimization is not working as usual while using with Aggregator transformation of mapping in IICS
Problem Description
Full pushdown optimization with snowflake source and target is not working as expected while using with Aggregator transformation in mapping.
Cause
This issue occurred due to all columns were not provided in the group by category of Aggregator transformation which was mapped in Target field mapping option of target.

For PDO with Aggregator, user need to provide all columns mapped under field mapping of Target to group by category of Aggregator (as per product behavior).
Solution
This issue was resolved after providing all columns which were mapped in the field mapping category of Target, under group by category of Aggregator transformation.

Steps to resolve this issue are as follows:

1.  ​Go to Mapping > Aggregator > Group by category
 2. Assign all fields under Group by category in same manner which you are mapping for Target under Target Field mapping category.​
More Information
Applies To
Product: Cloud Data Integration
Problem Type: Configuration
User Type: Administrator; Developer
Project Phase: Configure
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:6/2/2020 3:06 AMID:617102
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)