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,550 points

edited Apr 2, 2018 by 93.lynn 48 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,550 points
162 views
0 votes
1 answer
0 votes
2 answers
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
200 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,320 points
169 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
145 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,320 points
64 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
45 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
333 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.