Make a select with TMAP

[Anonymous]

I have a this job, so i  make a join with tmap and i have the row dont match, so i want make a select with the information but i dont how do that.

i do with tflowiteration but not work . only get one row. So what is the better choice.

[Anonymous]

Hi,

    Unfortunately your query is bit vague. Could you please the scenario with 5 input records and show us the expected output for those 5 records. Please also specify the current erroneous output too.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Ok, i understand i explain the better form.

In the next images with have  1386 rows i want a make a select with 2 columns come from tmap_3 and i want use in tdbrow_1 but only get one row.

In the next image, put de select for tdbrow_1

[Anonymous]

Ok. Got it! Since you are using tFlowtoIterate, the job is processing one record at a time.

You can see that there were 1386 executions in the screenshot itself.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Yes, but how i can get with the select the 1386 in the tdbrow_1 or i need another component for do that?

[Anonymous]

How i can work?? What is the correct choise?

[Anonymous]

Hi,

   It depends on what your are trying to do within the tDBRow. If I have to increase throughput by processing the entire 3000+ records in one shot, I would try to load the entire data to a temporary table. Then I would use this table along with other tables inside tDBrow to do the same processing in batch mode.

   That way you can ignore the current method where one record is processed at a time.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

What I want is that the moment of receiving the 1386 records with pass to make a select that looks for an identifier taking into account two values that come from the tmap.