I have been experimenting with the loading of shared table definitions using istools.
I have then been using these definitions in Fasttrack to load csv mappings and generate a Datastage job.
But I have come up against an issue which I cannot understand.
When the column definitions are loaded into Metadata repository, and when they are displayed in workbench there is no column that
is available for 'scale' for example. Therefore when generating the job Fasttrack (quite rightly) generates for example a Decimal (22) column in Datastage, no scale
However I noticed that when you use Fasttrack and look at some column defs (presumambly imported directly) the scale is there and when you gen the job it correctly
puts the scale in place.
So when I try and run the generated jobs I get errors and have to modify the code, which was not the idea
Is it a deficiancy by design that the repository and shared tble defs dont have this detail?
Or am I missing something somewhere
regards
Tim
import shared tab defs - Decimal fields
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