Aggragator Issue
Posted: Wed Jul 30, 2008 7:49 am
I am getting the folloing error while using aggragate stage. CAn you tell me how can I give sort number and sort order for multiple column without getting error?
The error I am getting is like below
Agragator..Aggregator_1: Row out of sequence
At row 3, link "DSLink3"
Row out of sequence
I am doing the following.
Step 1: I have a sequential file source with 3 columns
Name Place Population
Arun Italy 10000
John America 5000
Step 2: I mentioned Name as Key in the Sequntial file source
Step 3: In the aggragator input page I put liek the the folloing.
Column Sort SortOrder Key
Name 1 ascending checked
Place 2 ascending unchecked
Population 3 ascending unchekcked
Step 4: In the aggragator output stage i put the folloing
Column group derivation Key
Name Checked name checked
Place Checked Place unchecked
Population unchekcked Avg(Population) unchekced
Step 5: Run and I am getting error above.
The error I am getting is like below
Agragator..Aggregator_1: Row out of sequence
At row 3, link "DSLink3"
Row out of sequence
I am doing the following.
Step 1: I have a sequential file source with 3 columns
Name Place Population
Arun Italy 10000
John America 5000
Step 2: I mentioned Name as Key in the Sequntial file source
Step 3: In the aggragator input page I put liek the the folloing.
Column Sort SortOrder Key
Name 1 ascending checked
Place 2 ascending unchecked
Population 3 ascending unchekcked
Step 4: In the aggragator output stage i put the folloing
Column group derivation Key
Name Checked name checked
Place Checked Place unchecked
Population unchekcked Avg(Population) unchekced
Step 5: Run and I am getting error above.