I am looking for a solution to read column dynamically from input.
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…!!