Hi All,
I have Job scenario like below.
source --> Aggrigator1 --> Aggrigator2 --> O/p
my source has 3 columns.
col1 as integer,col2 as char,col3 as integer
in Aggrigator1 I'm doing Calculation Sum(col3) --> col3_sum and
minimum value(col3) --> col3_min
For Aggrigator1 col1 and col2 are group key values.
now for Aggrigator2 my source is
col1, col2, col3_sum, col3_min
here I'm doing Recalculation Sum(col3_sum) ----> col3_total.
For this stage Group key is col1.
when i run this job i received error:
Aggregator_19: Error when checking operator: Could not find subrec "col3_Sum" [api\interface_rep.C:3312]
When i tried to recompile it i received compile time error in agrrigator2.
and when i checked on the Mapping's tab columns i found 2 more columns got added SummerRecNum(col3_sum) and SummeryNumMissingVals(col_sum).
Can any one tell me what is this why it is considering column as subrecord(may be vector) and how to use Recalculations in aggrigator.
Error in Recalculation for aggrigator stage.
Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 14
- Joined: Thu Jul 10, 2008 7:37 am
- Location: mumbai
Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration