I think it should work for both of the scenarios. Please generate the execution plan in 'Verbose Initialization' mode and search for the CLUMP keyword in it. The verbose init log should have the below
1. the actual FlexPartitionSpec2 property and its value
2. the CLUMP keyword next to the target object name
If you could see the above then it should enforce them during mapping execution. If the above (2) is missing in the log, try to change the optimizer level to NORMAL and regenerate the execution plan.
Execution plan gets stored in $INFA_HOME/..../disLogs/ms.
Hi Niaga Prima,
The mapping runtime property FlexPartitionSpec2 can be used with static as well as dynamic mappings. And the same could be parameterized as well.