I need to build my source qualifier query like
select * from tablea where $$mapparm1
here $$mapparm1 is a mapping parameter which might have where condition value like (Col1 = 1) or (col1>1 ).
Is this possible.. i mean building the dynamic SQL and running by using something like Exec command.
See the section in the Workflow Administration Guide on mapping parameters. A string mapping parameter can hold any text and could hold the entire condition you want to express.
Though this post was an oldone, For people who search for anything like the above.. Just want to share that it is possible to have a Mapping Variable used nto a SQL query as below,
select * from tablea where $$mapparm
This requires first to define a Mapping Variable - $$mapparm (Make sure to have the data type of the Variable set to string).
This should work good if defined the value or the where condition through the Parameter file like any other Parameter value defined.
Mahaveer Singh S.