Can we use dataset value to refer in techincal rule

[RG14]

we have lot of conditions in technical rules, so we are planning to add values in dataset and then refer those values from dataset in technical rules. will it impact the performance.

[Amar_Simha]

@RG14 : Yes, dataset can be used in technical rule. Please refer below.

https://forums.saviynt.com/t5/identity-governance/dataset-in-technical-rules-amp-user-update-rules/t...

[RG14]

@Amar_Simha will it cause any performance issue

[Amar_Simha]

We did not observe any issue far, but I will let forum experts advise on the same.

[rushikeshvartak]

Yes you can use dataset. And performance issue is based on no. Of users and values in dataset which will need scanning time

a.email IS NOT NULL AND (substring_index(a.email,'@',-1) in (SELECT attribute1 from Dataset_Values where datasetname = 'dataset'))

[PremMahadikar]

Hi @RG14 ,

I don't see any performance issue either.

Sample code for reference:

• a.userkey=998877 and a.customproperty22 in (select distinct dataset_values.attribute1 from dataset_values where dataset_values.datasetname = 'City' )

If this helps, please consider selecting Accept As Solution and hit Kudos