Read column name dynamically


I am looking for a solution to read column dynamically from input.

For Example:

Step 1: I am using oracle execute snap to pass the schema.tableName to read the data. In this case lets assume my table name is ‘employee’.

Step 2: Then I wanted to read the column dynamically from ‘oracle execute snap’ and pass it to next snap.

Step 3: If I change my table name from ‘employee’ to ‘department’ then I don’t need to reconfigure any other snap.

I need dynamic schema. I don’t want to use mapper because that will fix the schema.

Could anyone help me here please.

Thanks in advance…!!