I am currently working on Datastage 6.0 with Parallel extender. It is required to merge 4 sequential files based on a key value. For ex:
Structure of File 1 : EmpNo, Name
Structure of File 2 : EmpNo, Dept
Structure of File 1 : EmpNo, Age
Structure of File 2 : EmpNo, Salary
I have to merge these files which will have following structure :
EmpNo,Name,Dept,Age,Salary
All files may have different employees. It is required to capture all the employees which are there in any of the file, other fields can be null in that case.
While trying with MERGE Stage or JOIN stage, the final result is only the employees common in all files with the records rejected have following warning message :
Sequential_File_7.DSLink8,0: Field "Name" is null but no null export handling is defined
Note : I have specified all the fields as Nullable
Any help with this simple looking job is highly appreciated.
Thanks a lot in advance.
Best Regards
Pinkesh Kothana
Technical Specialist
Infosys Technologies Ltd.
Merging Sequential files
Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”
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