- Data Integration
- All Products
Updated March 06, 2023
I would appreciate more documentation on the advanced filter option. My use case is checking a destination table for the max date and then querying a source table to find data newer than my max date. What syntax is valid in the advanced editor, could I used a unconnected lookup and reference the value. The advanced editor doesn't have the same reference functionality as the expression builder, so it is difficult to tell what is possible.
Hi Sam Greene. There is some additional information about advanced filters in the topic Data Filters in Tasks. We’re working to address the comments you entered about your use case and about adding additional information to this section of the documentation and will get back to you. Thanks, Informatica Documentation team
Hi again Sam Greene. We've checked with our QA team and they recommend that you use an in-out parameter to store the max date for data that has been loaded to the target during each mapping run. In-out parameters can be used in a Filter transformation or in the source filter to ensure that you are only reading rows that were not processed during the previous mapping run. You can find more information about in-out parameters in the "In-out parameters" topic in Mappings. Using an unconnected lookup is probably not the best approach in this case since your source data is not static.
If you need further help with your specific use case, please reach out to Informatica Global Customer Support.
We will file a documentation enhancement request to add more information about valid syntax in the advanced filter editor.
Thanks, Informatica Documentation team