Can a Query Activity update a Data Extension in real time?

Hi Chanchal,

Yes, a query activity can update the data extension in real time. You would need to:

1. Create a new data extension containing a subscriber/recipient field as the Primary Key and also add boolean fields for link1, link2, link3, etc.
2. Create a Query Activity to update the Data Extension you created from Step 1 so that it updates the boolean fields in the DE for each recipient.
3. Create a one-to-one cardinal relationship to the data extension you created in step 1 in Contact Builder, mapping the recipient identifer back to the Contact Key of the Contact Record.
4. Now you can use Split conditions from journey builder to update the data extension.