Hi all,
A brief background.....
Our client has an enterprise financial datawarehouse running on Oracle 7 and Express 6.2 (ROLAP arch), and it is not happy with the performance. Issues relate mainly to ETL and maintenance part. Currently ETL is handled thru PL/SQL procedures. We intend to perform this task using Ardent Datastage. Also, we also plan to migrate the DW from Oracle 7 to 8i to take adv of OLAP features of 8i.
The problem.....
Since im new to Datastage, my query is regarding that. The ETL logic of stored procedures can be built into Datastage stages/jobs. That way we eliminate the PL/SQL routines. The other option is to call the same PL/SQL routines from Datastage jobs (since those routines r already there). Or perhaps a third option can be to use an optimal mix of the prev two options (what is optimal?) Whats the best thing to do? Are there guidelines that help in deciding what to do within Datastage and what to do outside(PL/SQL)?
Regds,
Vivek Pandey
Consultant - BI
http://sonata-software.com
email: vive@sonata-software.com
PL/SQL Vs. Datstage jobs
Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.
Return to “Archive of DataStage Users@Oliver.com”
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