Looping through all the schemas in Talend

0 votes

I am trying to loop through all the available schemas of my Oracle database but so far not able to succeed. Following are the tasks which I am performing:
1. Establishing a connection
2. Using an existing schema to fetch the data at
tOracleInput component
3. Assigning a variable, using tJavaRow component
4. Iterating through the data using tFlowToIterate component
5. Using tOracleRow component, alter the schema that was retrieved at step 2
6. Writing a query to generate certain output.

image
Everything works fine until step 5. But once it reaches step 5, it keeps on iterating for all the schemas before moving on to the step 6.

Issue:
My problem is, I want to execute step 6 before it starts the iterations, so that it processes a single schema at a point 
of time. Can you suggest any solution for this?
Thanks in advance!

Apr 2, 2018 in Talend by 93.lynn
• 1,590 points

edited Apr 2, 2018 by 93.lynn 137 views

1 answer to this question.

0 votes

It is really simple to make tOracleInput part of the loop. All you need to do is use "OnComponentOk" trigger from tOracleRow component to link the tOracleInput component:

image

answered Apr 10, 2018 by code.reaper12
• 3,450 points

Related Questions In Talend

0 votes
1 answer

Naming the output based on a column value in Talend

You can try to solve this problem ...READ MORE

answered Apr 19, 2018 in Talend by 93.lynn
• 1,590 points
395 views
0 votes
0 answers

Read Data from Rest API's through Talend and store it in Oracle

Hi Team, Can anyone help me how to ...READ MORE

Oct 31 in Talend by Abhishek
• 150 points
32 views
0 votes
1 answer
0 votes
1 answer

Adding third party libraries into the Talend project

You can add the 3rd party libraries ...READ MORE

answered Apr 9, 2018 in Talend by code.reaper12
• 3,450 points
457 views
0 votes
1 answer

tWaitForFile component insufficiency in Talend

Regarding your first issue, tWaitForFile component provides ...READ MORE

answered Apr 10, 2018 in Talend by geek.erkami
• 2,640 points
402 views
0 votes
1 answer

Downloading files using Talend Studio

As per my understanding, I think first ...READ MORE

answered Apr 11, 2018 in Talend by code.reaper12
• 3,450 points
307 views
0 votes
1 answer

Implement Common Logging in Talend

Well, you can try using following 2 ...READ MORE

answered Apr 11, 2018 in Talend by geek.erkami
• 2,640 points
184 views
0 votes
1 answer

Specifying the number of Rows Processed in Talend

Hi, you can try using tSampleRow component ...READ MORE

answered Apr 14, 2018 in Talend by code.reaper12
• 3,450 points
116 views
0 votes
1 answer

Parsing JSON in Talend

While working with JSON files, one thing ...READ MORE

answered Apr 2, 2018 in Talend by code.reaper12
• 3,450 points
590 views