I am facing a case with inner join over two mssql tables name T1(main) and T2 (lookup). When T2 is having no data at all, the inner join reject works perfectly and goes to the reject output . But when T2 has some rows, say 40 and T1 is having 100 rows, all 100 rows are going in the main output and reject is being blank, instead of (40 main + 60 reject). So, it works as left outer join in case T2 has some data.
Has anyone faced the same issue and help me in resolving this?
Note: My main and reject output tables are same as the T2 table with different entries defined in the tmap.
as far as I can see from the tMap screenshot, the outputs do not have any data from the lookup. So I thought it might make a difference whether the reject output is processed first or second. My apologies if this is wrong.
