Hi,
I'm using this:
hashed file --> Aggregator --> hashed file
In the first hashed file, I'm having 11 columns, 10 of them are keys. In the second one is the same but with 8 keys. When I sumarize using aggregator, it gives me the same ammount on both hashed files.
The hashed files characteristics are the same.
Any ideas?
Thanks,
no sumarized records using Aggregator
Moderators: chulett, rschirm, roy
Not without a better idea what kind of 'summarization' you're doing in the Aggregator. Are you grouping on the 8 keys you've mentioned? Doing what with the other fields? And by 'same amount on both hashed files' are you saying that the number of records pulled from the first hashed file is the same number of records coming from the Aggregator to the second hashed file? If so, have you confirmed how many records are actually in the second hashed file?
And I'm also unsure what you mean by saying the 'hashed file characteristics are the same'... in what way, specifically?
In other words, I think we need to take another stab at explaining your issue.
And I'm also unsure what you mean by saying the 'hashed file characteristics are the same'... in what way, specifically?
In other words, I think we need to take another stab at explaining your issue.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This would be a valid result if each combination of the first eight columns in the source hashed file had only a single row associated with it.
You can check whether this is the case using an appropriate query, probaby with HAVING COUNT(*) > 1 as one of its clauses.
You can check whether this is the case using an appropriate query, probaby with HAVING COUNT(*) > 1 as one of its clauses.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 457
- Joined: Tue Sep 25, 2007 4:05 pm
Re: no sumarized records using Aggregator
Also, please bear in mind, I am sure you know about it, that if the 10 keys are the same for any two records, the previous record will be overwritten inside a Hashed file.boligoma wrote:Hi,
hashed file --> Aggregator --> hashed file
In the first hashed file, I'm having 11 columns, 10 of them are keys. In the second one is the same but with 8 keys. When I sumarize using aggregator, it gives me the same ammount on both hashed files.
The hashed files characteristics are the same.
Thanks,
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
Experience is what you get when you didn't get what you wanted