All,
I have created a job which will fetch data from a table and load it in two files.
format:
fund_id
fnd_dt
fund_cd
qty
price
i will fetch the above information and store it in two file based on the below logic.
1) If fnd_cd = 'C' then i will aggregate it and store it in a file
2) if fnd_cd <> 'C' then i will store all the entries in another file.
say for example,
i have like below
1 17/jul/2009 T 22 25000
1 17/jul/2009 C 2 500
1 17/jul/2009 C 2 100
1 17/jul/2009 D 13 4566
1 17/jul/2009 E 12 4440
1 17/jul/2009 Q 20 5800
I will aggregate the above bold one and store it in a seperate file say for example file2.
my problem is all the values are coming in file2.
i.e
first row is aggregated value
remaining rows also appended from the second row onwards.
But the job shows only one row transferred. How it is possible?
where i am doing mistake?
Aggregation
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 48
- Joined: Tue Nov 25, 2008 11:10 pm
- Location: Des Moines,IA
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
Re: Aggregation
I have also created an constraint saying if fnd_cd = 'C' then move it to file2
if fnd_cd <> 'C' then move it to file1.
if fnd_cd <> 'C' then move it to file1.
Karthik
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
-
- Premium Member
- Posts: 48
- Joined: Tue Nov 25, 2008 11:10 pm
- Location: Des Moines,IA
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Unless I am missing something in your posts it seems like constraint you have posted is not complete or you have mentioned same filename as file1 and file2 in append mode or some thing is missing from your explanation.
can you post your exact constraint syntax? also are you using otherwise link as your input to aggregator stage?
can you post your exact constraint syntax? also are you using otherwise link as your input to aggregator stage?
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: