cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Create reusable lookup that we call multiple times in the same pipeline

Akash_Srivastav
New Contributor II

We have requirement where we have multiple data quality rules configured in a Oracle table for each pipeline that loads different tables. Each rule also has a severity associated with it. Ex: If when are reading Employee data we want to check if Employee number is null(High Severity issue) and also Department Code is null(Low Severity Issue). Questions

  1. How do we make these null-ability checks or other generic checks reusable so that we donโ€™t
    need to re-code it every single time

  2. Can we make a lookup reusable so that in the same pipeline we can lookup on our rue table and fetch the severity for different rules. So if we have 5 rules, want to lookup 5 times

3 REPLIES 3

kichcha
New Contributor II

Were you able to resolve this? If so, can you please share the solution?

Hi,
We have a similar scenario. Can you please share the solution if it is resolved.

skatpally
Former Employee

One way to do this could be writing the Expression(Null Check or any validation Check) in the .expr file and then do a lookup.i.e lib.conf.validityCheck($Event.id) ( Field Name $Event.id you want to perform the validation on)

Refer to the documentation for more details.

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438110/Expression+Libraries