For handling a daily file drop that requires immediate processing:

File Drop Automation: Use File Drop Automation triggered by the presence of a new file on the SFTP. This automatically starts the import and subsequent data handling processes.

Workflow Details: Start with an Import File Activity to load data into the staging data extension, followed by SQL Query Activity 1 to segment the data into one target data extension and SQL Query Activity 2 for the other.