How exactly do you use this mapping variable?
In a Filter condition? If so, could you please post the filter condition here?
Or in a SQL Transformation? In this case please post the SQL statement you're issuing.
This question was answered in this thread:
SP K achieved it with target based loading in the same mapping with 2 mapping flows.