We have set of journey emails which will be deploying based on subscriber activity. But we have to get complete journey subscriber activity details in one Data Extension. Is it possible to get it by using Query?
Yes, we can get the complete journey subscriber activity details in one Data Extension by writing queries on system data views.
SFMS provides data views like
_Subscribers. You can join all these data views to get the required data into our data extension.
Here are a few examples for you.