Users Online
· Guests Online: 6
· Members Online: 0
· Total Members: 188
· Newest Member: meenachowdary055
· Members Online: 0
· Total Members: 188
· Newest Member: meenachowdary055
Forum Threads
Newest Threads
No Threads created
Hottest Threads
No Threads created
Latest Articles
DEMO - Oracle Data Integrator Essentials
DEMO - Oracle Data Integrator EssentialsOracle Technologies |
| Categories | Most Recent | Top Rated | Popular Courses |
 | Uploader | Date Added | Views | Rating |
| Superadmin | 01.01.70 | 481 | No Rating | |
| Description | ||||
| What You Will Learn Get to know the difference between ETL and ELT Find out how to make the best use of ODI objects such as joins, datasets, filters, and sequences Build workflows based on packages to execute a process Define your strategy with Knowledge Modules and adapt these module to your needs Create reusable pluggable procedures for recurring tasks Perform your daily tasks such as administration, maintenance, and deployment easily Understand how the architecture of ODI can be set up and how and where ODI stores its metadata Comprehend the use of scenarios as the smallest deployments units in ODI Discover how solutions are used to resolve dependencies between different ODI objects Authors Andreas Nobbmann Andreas Nobbmann is a specialist in Oracle DWH and Business Intelligence, and has been working as a consultant in this field since 1998. With a vast know-how and substantial experience, he coaches and advises clients, teaches courses, and manages different Oracle DWH/BI projects. His expertise ranges from backend tools, such as the ELT tool Oracle Data Integrator (ODI), to frontend technologies, such as the Oracle BI Foundation Suite and the multidimensional Oracle database Essbase. Besides being a passionate Linux user, Andreas is active on Twitter (@ANobbmann), and keeps a blog about many interesting tech topics, which can be found at http://blog.trivadis.com/b/andreasnobbmann/default.aspx. Currently, Andreas occupies the roles of Principal Consultant and Technology Discipline Manager within Trivadis AG in Switzerland, a top Swiss IT service provider that invests more than 5 million Swiss Francs per year in Research and Development. With his skill set, Andreas leads research on Oracle BI topics and has the freedom to check out the upcoming technology releases, such as the newest OBIEE 11g and ODI releases, and new features, for example, the new Oracle 12c database DWH/BI features. Table of Contents THE ODI CORE CONCEPTS Key ODI Concepts Differentiating between ETL and ELT Exploring the Graphical UI ODI Basics Defining Your Strategy The ODI Staging Area DEVELOPING IN ODI – THE CORE OBJECTS Organizing Your Project Creating an Interface Using Joins, Data Sets, Filters, and Sequences Using Temporary Interfaces and Lookups YOUR DATA TRANSFORMATION STRATEGY – KNOWLEDGE MODULES Adapting Knowledge Modules to Your Needs Executing Data Transformation in an ODI Interface Executing a Mapping on Your Source WORKFLOWS IN ODI Creating a Workflow in ODI Reusable Workflows: Procedures User Functions as Useful Functions Customize Development Objects in ODI DATA QUALITY AND DELTA DETECTION Oracle Data Quality Products Using Data Integrity Controls and Integrating Data Quality in ODI Running EDQ Delta Detection via CDC VERSION MANAGEMENT AND DEPLOYMENT Version Management Scenarios: Smallest Deployment Units Solutions Export and Import OPERATING AND MAINTENANCE Loadplans ODI Repository Tables Security ADDITIONAL SUPPORTING FUNCTIONS How to Automate ODI Object Creation Impact and Data Lineaging ODI Studio Enhancements | ||||
Ratings
Comments
No Comments have been Posted.
Post Comment
Please Login to Post a Comment.