topic Re: Make a select with TMAP in Talend Studio

Make a select with TMAP

Anonymous — Sat, 16 Nov 2024 05:19:54 GMT

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.

Re: Make a select with TMAP

Anonymous — Wed, 10 Jul 2019 02:14:43 GMT

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 🙂

Re: Make a select with TMAP

Anonymous — Wed, 10 Jul 2019 14:17:53 GMT

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

Re: Make a select with TMAP

Anonymous — Wed, 10 Jul 2019 14:22:47 GMT

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 🙂

Re: Make a select with TMAP

Anonymous — Wed, 10 Jul 2019 14:27:20 GMT

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

Re: Make a select with TMAP

Anonymous — Wed, 10 Jul 2019 23:18:08 GMT

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

Re: Make a select with TMAP

Anonymous — Thu, 11 Jul 2019 03:13:37 GMT

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 🙂

Re: Make a select with TMAP

Anonymous — Sun, 14 Jul 2019 00:54:27 GMT

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.