Hi Team, I have bunch of queries sitting in my Oracle tables(queries in one of the column). I am trying to see if I can read the oracle table as source and use the column values(which has sql queries ) to be sent to database & get return value. Is there a component that can help me achieve that?
jdbc reader, sql execute components expect you to hard code the query. But in my case the query will come as value from one the table.
1 select count(*) from tab A
2 select count(*) from tab B
In the above example I wanted to use col2 as input and pass the values from Col2 to DB and assign the output to next transformation. Hope its clear.