I am developing a Dynamic Mapping where i am pulling various source table and loading into Hive. My requirement is to keep one dynamic mapping and offload the data based on some extract criteria. So that filter condition will vary for each table. Example - Filter condition for Source Table1 is RGN_CD='CA' / Table2 - Product = 'CAR' / Table3 - Order_id=123 and Order_Status='Y'.
How to achieve this in Dynamic Mapping? How to parametrize whole filter condition?
You can use a Parameter for the complete filter condition and use it under Dynamic Source-> Query-> Filter.