Hi All,
I have below requirement where I have created a topology using wallet feature where I entered just the jdbc like jdbc:thin:host@#project.v_username
And #project.v_username is refresh variable which will take the username from a database table username_details.
I have an interface which is loading data from a table to a table and my source table is present in multiple schema and I have to implement a loop which in each loop fetch the username from a table one by one and substitute v_username in topology and fetch data from that schema.
I have created my package like
#project.v-counter-to get the count of schema in the table username_details.
Evaluate V_counter greater than 0
V_username-which is getting username one by one like
Select username,row_num() over order by user and desc as counter from username_details where counter=#project.v_counter
Interface
Set variable v_counter increment by -1.
Now when I execute this package I can see variables getting substituted correctly in operator but in actual data getting loaded from only the first username in the table even though the variable v_username is getting substituted correctly.
Please let me know what can be the issue in this.