Tag Archives: development

New Book : Oracle Data Integrator 11g Cookbook


http://www.packtpub.com/oracle-data-integrator-11g-cookbook/book

I got hold on this book, this is first book i seen on ODI. Currenty reading it and will publish review soon.

Oracle Data Integrator (ODI) is Oracle’s strategic data integration platform for high-speed data transformation and movement between different systems. From high-volume batches, to SOA-enabled data services, to trickle operations, ODI is a cutting-edge platform that offers heterogeneous connectivity, enterprise-level deployment, and strong administrative, diagnostic, and management capabilities.

“Oracle Data Integrator 11g Cookbook” will take you on a journey past your first steps with ODI to a new level of proficiency, lifting the cover on many of the internals of the product to help you better leverage the most advanced features.

  • 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 profiles
    • Creating 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 behaviors
    • Using 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
    • Introduction
    • Defining 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
  • Chapter 10: Advanced Coding Techniques Using the ODI SDK
    • Introduction
    • Creating the Master and Work repositories using the SDK
    • Creating a project using the SDK
    • Automating the import of artifacts using the SDK
    • Creating models and datastores using the SDK
    • Creating an interface using the SDK
    • Invoking and monitoring a scenario using the SDK
  • Chapter 11: More on ODI
    • Introduction
    • Invoking an external program that requires a password
    • Tuning a standalone ODI agent
    • Loading a file containing a LOB
    • Using ODI versioning
    • Performing a Smart Export/Smart Import
    • Accessing an Excel spreadsheet
    • Impacting the data flow by changing the staging area location
    • Automating Smart Export/Smart Import with the ODI SDK

http://www.packtpub.com/oracle-data-integrator-11g-cookbook/book

Aside

Template Form in Oracle Apps This document provides an overview of the template form. This form derives its importance from the fact that this form is the starting point of all development involving forms. The document highlights the importance of … Continue reading

Aside

Hello Friends, here i am posting some of basic oracle applications questions , will try to collect more and put in future posts, here i am putting quite easy and basic questions. If you like to know Questions of any … Continue reading

Aside

Distinction between configuration, personalization, and extensibility. Configuration provides setup and administrative choices using the native features of the product. Some configuration examples include: Profile Options User-defined fields (Flexfield) Function Security Setup Data Security Setup and a lot more…. Personalization enables … Continue reading

Aside

    Question: What are the Pct Free and Pct Used Answer:  Pct Free is used to denote the percentage of the free space that is to be left when creating a table. Similarly Pct Used is used to denote … Continue reading

Aside

SQL*Loader is an Oracle utility that enables you to efficiently load large amounts of data into a database. If you have data in a flat file, such as a comma-delimited text file, and you need to get that data into … Continue reading

Aside

Question: Which triggers are created when master -detail relation? Answer: 1) master delete property*  NON-ISOLATED (default) a) on check delete master b) on clear details c) on populate details  *  ISOLATED a) on clear details b) on populate details *  … Continue reading