topic Re: Loop through all the schema's in Talend Oracle in Talend Studio

Loop through all the schema's in Talend Oracle

Anonymous — Mon, 28 Dec 2015 10:41:16 GMT

I am struggling with looping all the schema's in oracle. What i need to achieve is as shown below

Create connection
Use the existing to fetch the schema
tOracleInput2tJavaRow to assign variable
tFlowToIterate for Iterations
Alter session based on schema fetched at step 2 using tOracleRow_1
Now i need to execute query and generate certain output and that will require one or more steps
But the issue is the that ,it will iterate till step 5 ,and when all the iterations are done ,it moves to step 6,i want to add step 6 and more in the iterations ,so that it will run for 1 schema at a time at a time .

Re: Loop through all the schema's in Talend Oracle

Anonymous — Tue, 29 Dec 2015 02:25:18 GMT

Hi,

But the issue is the that ,it will iterate till step 5 ,and when all the iterations are done ,it moves to step 6,i want to add step 6 and more in the iterations ,so that it will run for 1 schema at a time at a time .

It is normal to run for one schema at a time if your use "iterate" connection type.
What's your job requirement ? Dynamic query?
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina

Re: Loop through all the schema's in Talend Oracle

Anonymous — Tue, 29 Dec 2015 05:49:19 GMT

My Requirement is , i am going to fetch multiple schema at tOracleInput_1 (like Schema1,Schema2..)
at tOracleRow_1 i am altering the session to switch to schema1 and then tOracleInput_1 to fetch data from schema 1,But the iteration works it toracleRow_1 ,which means it will iterate till schema_n and then it comes to tOralceInput_1,which i dont want , I want to include toracle_1 in iteration .
Hope its clear now