This is what we want to do:
We want to remove the expression in the age attribute of the Recipients schema (this attribute is an out of the box one) and use the same expr/calculation in a ETL wkf instead in order to unload the CPU.
Current data schema (we use an extension of nms:recipients table) with the attribute we want to change:
We want to move the expr="YearsOld([birthDate])" from this table and use it in a ETL wkf instead:
Are there any risks in case for example of future ACC updates?
Thanks for your patience.
@a_b_se , Yes.. You can do that and there won't be any impact.
But, @age is not an SQL field attribute. it is a 'SQL Calculated field'. So removing the expression in Extended schema and updating in ETL workflow wont work.
You need to follow below steps:
In your extended schema, add the below code inside element tag
<attribute _operation="delete" name="age"/>
<attribute label="Age" name="age" type="long"/>
This script remove the OOTB expression (there wont be any impact), and create a SQL Field in database with name as @age
Update the database structure > logout and reconnect
Now in your workflow, use the Update data activity to update the age as per your screenshot.
For the first time, fetch all the recipients in a query and update their age using your workflow.
~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
