topic Correct output into a table when fetch with conditions and wrong output for a column when an output flow with no conditions. in Talend Studio

Correct output into a table when fetch with conditions and wrong output for a column when an output flow with no conditions.

Anonymous — Sat, 16 Nov 2024 03:41:54 GMT

Hi to everyone. I encountered a problem. I load person data from a table and fetch a person number from another table. I join the tables using tmap component and four fields SURNAME, NAME, LASTNAME, BDATE that are in every table by dragging and dropping the fields from first table to another like on the picture: 'https://yandex.by/images/search?p=5&text=talend+join&pos=174&rpt=simage&img_url=https%3A%2F%2Fstatic.issue.life%2Fcontent%2Fimg%2F18-07-2019%2F636990226562290625.png&lr=157'. Everything is OK till i fetch and load with conditions like "select * from MYTABLE_NAME where SURNAME='IVANOV' AND NAME='IGOR'". But when no conditions is then a field 'NAME_ORG' gets wrong random values. The values are different every load, but it is true only for one field and varies between free or four constant values. The wrong values related to persons with absolutely different PERSON_ID. Other fields look correct. I use Talend open studio data integration 6.5. I tried to set match model to 'All matches' and 'unique match', tried to set join model to 'inner join' and 'left outer join' but it does not affect. My project contains: 2 toraclerow, 2 tparserecordset, 1 tmap, 1 tmssqloutput. Can anyone help?

Re: Correct output into a table when fetch with conditions and wrong output for a column when an output flow with no conditions.

tnewbie — Fri, 03 Jan 2020 17:10:42 GMT

I guess, 'Catch lookup Inner join reject = False' will correct the issue 🙂

Re: Correct output into a table when fetch with conditions and wrong output for a column when an output flow with no conditions.

Anonymous — Fri, 03 Jan 2020 18:03:22 GMT

No, i tried to do reject into a file earlier, but i load all data into the same destination, so it does not make sense, this option is false by default. Besides i set join model to left outer join, join reject with value true does not produce any output in this case.

Re: Correct output into a table when fetch with conditions and wrong output for a column when an output flow with no conditions.

Anonymous — Wed, 15 Apr 2020 14:40:47 GMT

I looked througth every element and found that almost every of them had different input and output shemas. I thought the controls are clever enouth to match input and output. But after i deleted all controls and added them one by one setting properties and folowing that intput and output match the output got right.