A SQL override or a user defined SQL filter cannot be used with database partitioning and dynamic partitioning.
A feature request (CR 189703) has been created to add this functionality in a future release.
Use a Filter transformation after the Source qualifier to add the filter conditions.
"You cannot use dynamic partitioning if the source qualifier includes a SQL query or source filter" while saving a PowerCenter session with dynamic partitioning (120547)
Session runs with a Single Partition although ‘Dynamic Partition based on number of CPU's’ option is enabled (106501)
What can we do to improve this information (2000 or fewer characters)