Cargando…
Oracle Data Integrator 11g cookbook : over 60 field-tested recipes for successful data integration projects with Oracle Data Integrator /
Written as a practical Cookbook, the recipes in this essential guide will help you make the most out of Oracle Data Integrator 11g. This book is meant for people who already possess a basic understanding of Oracle Data Integrator and want to take it to the next level by learning how to better levera...
| Clasificación: | Libro Electrónico |
|---|---|
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2013.
|
| Temas: | |
| Acceso en línea: | Texto completo Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; Foreword; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Installation, Deployment, and Configuration; Introduction; Deploying and configuring a standalone agent manually; Deploying a JEE ODI Agent; Configuring a standalone agent with OPMN; Deploying JDBC drivers with a JEE ODI Agent; Chapter 2: Defining the Oracle Data Integrator Security; Introduction; Setting up LDAP security for Oracle Data Integrator; Setting external authentication with Oracle Data Integrator; Creating users using generic profiles.
- Creating users using non-generic profilesCreating new custom profiles in the Security navigator; Chapter 3: Advanced Topology; Introduction; Creating a new technology; Modifying actions to get more from your diagrams; Modifying and expanding datatypes; Changing the case sensitivity for code generation; Best practice
- using the Staging Area User to access your target schema; Chapter 4: Using Variables; Introduction; Passing start-up parameters to a scenario using variables; Using table names that run in all contexts using getObjectName; Using variables to filter data based on a timestamp.
- Using variables in KM options (and reusing the variables in an interface, package, and so on); Using variables in topology; Using variables to control loops inside packages; Chapter 5: Knowledge Module Internals; Introduction; Using the substitution passes; Using Java variables in KMs; Using Java for condition code generation; Invoking Java from the KMs; Using substitution methods in Java; Combining substitution methods in a KM; Chapter 6: Inside Knowledge Modules
- SCD and CDC; Introduction; Implementing Slowly Changing Dimensions (SCD) using ODI.
- Modifying a Slowly Changing Dimension KM to allow undefined behaviorsUsing Changed Data Capture (CDC)
- simple; Using Changed Data Capture (CDC)
- consistent set; Using one single interface to load changes that occur in any dimensions; Chapter 7: Advanced Coding Techniques; Introduction; Using diagrams to develop and maintain models; Generating DDL from data models; Generating interfaces from data models or diagrams; Creating a temporary interface (subquery); Loading data from an SQL query; Performing a pivot; Loading data using partition exchange; Chapter 8: Package Loops and File Processing.
- IntroductionDefining packages and loops for near real-time execution using a hybrid loop; Using a file from a parameter variable; Detecting files with a variable name; Processing all files in a directory; Processing a large number of files in parallel; Chapter 9: XML and Web Services; Introduction; Defining a connection to XML within ODI; Processing complex files with ODI; Processing XML data within an RDBMS not in memory; Invoking web services from ODI; Invoking asynchronous ODI web services with callbacks; Configuring container-based authentication with ODI web services.