3 Replies Latest reply on Sep 15, 2021 4:20 AM by JanLeendert Wijkhuijs

    Filter Transformation Pushdown Optimization

    Munesh Yadav New Member

      Hi,

       

      I am using a filter transformation just after the source object. I have read some articles regarding the filter pushdown that the query you have written in filter transformation is processed by the the source.

       

      But while trying with different queries I found that all the queries were not processed by the source.
      I want to know what kind of queries does informatica pushdown to source object.

       

      Here are some examples that I have tried.

      Query in Filter Transformation

      Query received by source

      Salary>10

      10<Employee.Salary

      Salary>10 AND Id>20

      Employee.Salary>10 AND 20<Employee.Id

      Salary>10 OR Id>20

      Nil

      abs(fee)>201

      Nil

      Salary>10 AND Id>20 AND ABS(fee)>20

      Employee.Salary>10 AND 20<Employee.Id

      Salary>10 AND Id>20 OR ABS(fee)>20

      Nil

       

      I am using IDQ.

       

      Thanks