Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

Source Insert Filter

Provide some way to filter the SOURCE INSERT rule. This used to be done because the ADM Source Insert was a cranport package and could be filtered with a where clause. Now it's dynamically generated as static sql based on the field mapping.


OPTIONS:

Filter the SOURCE DATA in the Snapshot.

Create a VIEW of desired records and map off that view.

Add a WHERE CLAUSE to the primary source.

  • John Munkberg
  • Feb 23 2023
  • Attach files
  • Eric Weldon commented
    28 Feb 10:06pm

    I think using a view would be the easiest option here. Maybe the view would have to contain the primary keys and then behind the scenes the insert would join to the view and only insert the records based on view criteria