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
Migrate
  • Attach files
  • Sebastian Di Grillo commented
    05 Jul 08:20

    I think having a filter option would be better than creating filtered views, because the filtered views approach:


    1) Need additional work in general and mostly in the backend to create the views.

    2) The filter logic remains in the backend (not in ADMM as an attribute that can be copied/exported).

    3) The Source Table name becomes larger (with additional view characters). Although "Legacy Table Rename" can be used as alternative.


    ×

    Attachments Open full size

  • Guest commented
    August 17, 2023 20:32

    solution is to create a view of primary source in SRC filtered as needed. Import view into metadata for working database. Manually assign keys to view in metadata. Now view can be used as primar source. table rename should also be used to get the source table name back to the base table name

    ×

    Attachments Open full size

  • Eric Weldon commented
    February 28, 2023 22:06

    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

    ×

    Attachments Open full size

Related ideas