Is it better to create a query with filtering within the query to populate a data extension - or - do you create a query and then create a filtered extension based on your parameters?
My use case is this:
I have a population of 3.8MM. I need to create a combined data extension based on that large [Users] data extension and a data extension called [Stores] which represents store owners (that are also users). I'm using an Inner Join on the Contact_Key(subscriber key).
From there I need to filter that list of stores based on whether they are open, active, and within a certain range for a close date. Currently, running an automation for a filter activity after a query activity. Is this best practice? Or would it be more scalable to just run queries with filtering logic written within the query?