Join error - invalid record count

[deesh]

Hi,

Hi we are doing inner join with join stage, but result is not coming properly

Ex: from source getting 400 records after join it is giving 5 records but as of our think it suppose to give 400 records.

If i do same inner join with lookup, it gives 400 records result in output

If i do same inner join with Merge, it gives 5 records to master table and remain 395 to secondary link,

I checked with data, there is no issue with data even,,

Pls some one help in this one.

[deesh]

I have changed to sort mode instead of hash in Aggregator stage. by this solution is issue is resolved

[soumya5891]

Are you using join after aggregator? If so and using sort method in the aggregate then sort the input on the basis of aggregation key.

For larger no of distinct key combination use sort method otherwise hash method in aggregator stage