Correct output into a table when fetch with conditions and wrong output for a column when an output flow with no conditions.
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...'. 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?
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.
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.
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.
