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.
Join error - invalid record count
Moderators: chulett, rschirm, roy
Re: joiner error
I have changed to sort mode instead of hash in Aggregator stage. by this solution is issue is resolved
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
Re: joiner error
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
For larger no of distinct key combination use sort method otherwise hash method in aggregator stage
Soumya