How to filter out zero amount/balances while pulling data from ERP GL using Data Integration?

Summary:

We are implementing a direct integration to load General Ledger (GL) data from Oracle Fusion into EPCM using Direct Data Integration.

During testing, we observed that approximately 97% contain zero values. This volume of zero-value records is significantly inflating the extracted data set we get error ": Number of query result cells exceeds the limit [1000000] set by the QUERYRESULTLIMIT" and is having a major impact on extraction and load performance 

We would like to understand whether there is a supported method to suppress or exclude zero-value records during the extract from GL within the direct integration process. Specifically:

1. Is there a configuration or setting in Data Integration that filters out zero-balance / zero-amount records at the source during the pull?