I have 2 tables named as table1- account and table2- category.
I am performing inner join operation in talend based on one column in table 1 inner join another column in
table 2.
If I am passing the same query in MySQL I am getting 411483 records ..but when I am performing the same query logic in talend I am getting 409321 records.. some 2162 records are missed when I am performing in talend.
Could anyone please explain me why the records are getting missed.
Example query is :
select * FROM (`account` `d` JOIN `category` `map` ON (((IFNULL(`d`.`category_only`, '') = IFNULL(`map`.`category `, '')))));
In the above query the category_only is the column in account table and category is the column in category table..
the both columns data type is same (string) but the column naming convention is different.
there are multiple records with null value for category_only column in account table and multiple records with null value for category column in category table, in mysql it this kind of data results in cross join.
1 Null category record in the account table matches with all null categories in the category table. This happens because of the null handling in your where clause.
Problem is not anything with talend components, it because of the data .
If you want the achieve same output numbers ,use tMap with inner join Model, & All Match Model
sorry that I didn't mention .. I used tmap to join two tables and gave inner join condition and also match model as all matches ... still I am facing the issue ..
