SYNITI ADMM where clause filter on Source insert rule

Answered

Aditya sayyapureddy

September 05, 2023 12:53

Hi Team,

We have the option to filter data in source package in ADM using where clause to filter data based on certain criteria . It creates a filter in the source package which filters the data from sdb Database to DSW database in while inserting intom source tables( st Tables)

As we are in SYNITI ADMM now , do we have similar kind of cuntionality which filters the data before inserting data into source table (_S) from SRC*** to WRK***.

For example I have MARC table and if i have to use it for one of the object and filter it based on plants how do we do it in mappings?

and when we have the concept of central relevancy (or source data preparation) How do we restrict the data in Transformation area to inset only the relevant records and apply the transformations over that.

Please check and let us know

-1

Comments

1 comment

Best answer
Mark Thompson

September 07, 2023 14:55
Migrate/ADMM Filtering Source Insert to Working Source Table

Overview

There is currently no native functionality in Migrate/ADMM for filtering the source insert from SRCXXX to WRKXXX. The following procedure can be used to achieve filtered data in the source insert.

Procedure

Create Filtered View of Source table in SRCXXX

In this Example we are filtering MARC in SRCECC to only contain WERKS 1000, 1100, 1200, and 3000. The view is named MARC_ACTIVE_WERKS

Filtered view of MARC created in SRCECC

Add View to Datasource Tables

Navigate Catalog->Datasources and select SRCECC and add MARC_ACTIVE_WERKS under Datasource Tables.

Add MARC_ACTIVE_WERKS as a Datasource Table

Edit MARC_ACTIVE_WERKS and select Import Metadata

Import Metadata for MARC_ACTIVE_WERKS

Column Metadata now available for MARC_ACTIVE_WERKS

Manually define the keys for the view MARC_ACTIVE_WERKS in the panel Datasource Columns

Keys Manually Defined in Datasource Columns

Register View as Primary Source

Navigate to Migrate->Mappings and add the view you created as the primary source. Optionally, specify the original source table name in Legacy Table Rename so that the physical working table has the same name as it would without using the filtered view.

Register filtered view as Primary Source

Summary

Although Migrate/ADMM does not natively filter source inserts from SRCXXX to WRKXXX, filtering can be achieved by creating a filtered view in SRCXXX, importing metadata, defining keys, and registering the filtered view as the primary source.
0