i have a DE that is a join result of two synchronized objects (campaign and campaignmembers ). it gets updated every 3 hours by a sql query that appends new records to target DE called master_DE. SQL also checks a field called [renponded = false ) to populate master_DE.
there is a 2nd sql that runs daily and updates only one field called (responded) on existing master DE records (pulling from same campaignmember synced DE object )
I would like to, on various points throughout the journey, to use contact data since it provides latest data , in decision splits to see if responded =true/false
is it possible to use the same entry source DE as contact data and if so can someone please give me the steps to set up master_DE as contact data? and what to do to make sure the decision split checks the field for the specific contact going through the journey.
thank you in advance