Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 51 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 288 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 111 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OLTP TO OLAP Data Transformation
Raghavendra Hari Nakka-Oracle
Rank 2 - Community Beginner
Currently we have mechanism of replication of data from OLTP to STAGE area and followed by transformation from STAGE to OLAP for reporting and analytics uses. These tasks are achieved by PL/SQL, Pipeline Designer and Oracle Data Integrator. We observed challenges in Pipeline Designer where it configures tables, PL/SQL procedures and other related tasks. We need more effective and developer friendly Pipeline Designer to perform jobs.
- Error Messages are not showing correct information
- Pipeline UI needs major enhancements
- Developer friendly options like connecting DB and writing PL/SQL jobs inside Pipeline Designer must be allowed
- Automatic table creation, job creation, mail alerts, auto restart of jobs, displaying correct error message popups are required.
- Complete documentation on each step performed in Pipeline Designer with screen shots is required.
1