topic Re: tMap inner join & output rejects in Talend Studio

tMap inner join & output rejects

Anonymous — Sat, 16 Nov 2024 13:24:42 GMT

When performing an inner join between two tables and in addition filtering the Main input data using expression filter,
what happens if i select both enable inner join reject option & the enable output reject options in one of the tMaps' outputs?
will the output give us the inner join rejects 'or' the main input flow expression filter rejects?

Re: tMap inner join & output rejects

Anonymous — Wed, 02 Jun 2010 09:41:46 GMT

see attached image...

Re: tMap inner join & output rejects

Anonymous — Wed, 02 Jun 2010 10:41:09 GMT

Hi
You will get the the inner join rejects, the enable output reject options acts on the filter expression of output table.

Best regards
Shong

Re: tMap inner join & output rejects

Anonymous — Wed, 02 Jun 2010 15:26:49 GMT

Thanks for the quick response!
Two additional related questions:
1. What happens when both reject flags are activated (inner join reject & output reject)?
2. If there is more than one output and more than one expression filter, lets say there are two ouputs and two expression filters, one for each output, (in the output of the tMap), how does the output choose which expression filter rejects to take?
Thanks!

Re: tMap inner join & output rejects

Anonymous — Thu, 03 Jun 2010 03:10:53 GMT

Hello

1. What happens when both reject flags are activated (inner join reject & output reject)?

It will merge all the inner join rejects and output rejects.

2. If there is more than one output and more than one expression filter, lets say there are two ouputs and two expression filters, one for each output, (in the output of the tMap), how does the output choose which expression filter rejects to take?

It will get the reject rows which don't exist in both the two output.
Best regards
Shong

Re: tMap inner join & output rejects

_AnonymousUser — Thu, 26 Nov 2015 08:01:47 GMT

H,
After a long while.
lets say i have set both "catch output reject" and "catch lookup inner join rejects" to TRUE.
now in the output component, how do i identify what is the cause for the reject?
i have joined 3 tables(lets say tableA, tableB, tableC), and have some expression filters. i want to identify rows rejected because join with tableA failed, join with tableB failed and join with tableC failed and expression filter separately.
is there a way?

Re: tMap inner join & output rejects

Anonymous — Thu, 26 Nov 2015 08:18:42 GMT

Hi Nusky,
Are you looking for tmap "ErrorReject"? What kind of errors are supposed to be captured?
Best regards
Sabrina

Re: tMap inner join & output rejects

_AnonymousUser — Thu, 26 Nov 2015 09:50:54 GMT

hi Sabrina,
i have rows in table A like: account_no, country_code, currency_code
A0001, SG, SGD
A0002,UK, GBP
in table countries: country_code, country name
SG, Singapore
UK, United Kingdom
in table curencies: currency_code, currency_name
SGD, Singapore dollar
GBP, Great Britain Pound
But there are 2 rows in Table A like
A0003, AA, SGD
A0004, UK, BBB
I can get A0003, A0004 in rejects output in tmap, but i want to know that A0003 rejected because AA was not in countries table and A0004 rejected because BBB was not there in countries table
is there a way to identify due to fail of which join row in table A was rejected?
Thanks, Nusky

Re: tMap inner join & output rejects

Anonymous — Sat, 09 Jun 2018 22:49:18 GMT

Hi Nusky,

You can pull two link for output to know which join fails .In first link you do only inner join reject(i.e if the value will present in table A and it will not present in countries table then it will go in reject.) and in second link you do only catch output reject (i.e it will based on your condition means it will catch the records rejected by a filter you have defined in the appropriate area).

Thanks

Avinash