ODIExperts.com

• ODI Expert and why there is no new posts…

• Passing Values to ODI Variables in Packages/Scenarios

• New Author Arriving…

• ODI Certification – Approved

• How to Change ODI Language (Idiom)

• Information about the ODI Certification Exam

• Finally!!!! The Oracle Data Integrator 11g Certified Implementation Exam!!!!!!

• Interface with Union, Minus Operator using ODI SDK

• Export and Importing Scenarios based on Project (or)Folder

• Creating Interface for Single Source and Target

• Creating Permanent Interface based on Model Level

• Automatically add Interfaces/Scenarios to new ODIPackage using ODI SDK

• Creating Package using SDK

• Handling the “ORDER BY” clause in an interface

• Creating Temporary Interface using ODI SDK

• Creating ODI Procedure using SDK

• ODI SDK Setup and Config in Eclipse

• Things to be pride of….

• CDC CONSISTENT

• Ordered SQL

• Killing session in ODI 11g

• 11g Oracle Data Integrator – Part 8/11g – Table Partitioning supported

• Jython Scripts fails to recognize the module during scenario run in ODI 11g

• Scenarios, a lot in the first delivery makes maintenance very simple!

• Direct load by interface with no work tables (C$, I$)

• 11g Oracle Data Integrator – Part 7/11g – SUNOPSIS MEMORY ENGINE

• 11g Oracle Data Integrator – Part 6/11g – Union , Minus, Intersect

• Jython’s Beginner Guide for ODI

• Send SQL by Email

• Security Module – Main concepts and use

• Drivers Location in ODI 11g

• 11g Oracle Data Integrator – Standalone Agent but, and about the Windows Service???

• 11g Oracle Data Integrator – Part 5/11g – odiConsole, the new Metada Navigator

• Using one of ODI’s lesser-known secrets: the Common Format Designer (CFD) – by Craig Stewart

• 11g Oracle Data Integrator – Part 4/11g – Upgrading from 10g

• 11g Oracle Data Integrator – Upgrading from 10g – Part 4/11g

• First year of many…. Thank you Friends!

• 11g Oracle Data Integrator – Part 3/11g – Graphical User Interface

• Datatypes – Creating what is missing for any technology

• IS_NUMBER (and IS_CHAR) at Oracle? A workaround…

• Calling OdiSqlUnload using ODI Procedure with no hardcoded password

• SNP_EXP_TXT – A “huge” table problem

• Internal ID

• SCD Type 2

• 11g Oracle Data Integrator – Part 2/11g – Creating Repositories

• 11g Oracle Data Integrator – Creating Repositories – Part 2/11g

• Regenerate ODI Objects using OdiGenerateAllScen

• Generate Column_name Header for OdiSqlUnload

• Error Records Log

• Get the Error Message of any Failed ODI objects inside Package

• SCD TYPE 3

• Best practice of ODI

• 11g Oracle Data Integrator – Part 1/11g – First Screen

• Automated ODI Export Import Scenarios

• LKM OdiSqlUnload(File) to Oracle ( SQLLDR )

• Jython OS bug in Windows 7

• Writing SQL counts using Jython

• Getting one or several unknown files from a directory

• Interface Parallel Execution – A new solution

• Displaying SQL results in Operator

• Flow Control and Static Control

• Export DWR to EWR [ Common Master Rep ]

• Scenario Report

• Asynchronous -Parallel Execution

• Dropping $ Tables

• KM FOR UNION BASED ON IKM SQL CNTRL APPEND

• Installing ODI in Windows 7

• Querying in ODI

• Changed Data Capture ( CDC )

• Agent

• Manual entry in ODI Driver List

• MINUS IN ODI

• Variable Detail Query

• Interface Mapping Query

• Topology Connection Detail

• Versioning

• Get File Length and Header in Operator

• Find the Value of the Variable in Operator ?

• Invisible Join

• Shortcuts Keys

• Export – Import DWR to EWR having same Master Rep

• Categorize Scenarios

• Alignment of objects in Package

• Duplicate Multiple Objects in Package

• Smart Search

• Export – Import DWR to DWR having same Master Repository

• Procedures (or KM) Steps – Source and Target tab’s

• Subscribers – An example of how to use

• Why Creating a separate schema in ODI?

• How to show Business Messages on Operator and, too, debug variables…

• Topology – Data Server – Which user should be used to connect?

• How to use PL/SQL procedures and functions in ODI

• Context, Logical And Physical Schema – How does it work?

• Repository Architecture – Work Repository, Development or Execution? When and why uses each one.

• Removing Special character using Jython script

• Faster and Easiest way to design Interfaces

• AUTOMIZE ODI REPOSITORY EXPORTS

• Informix Connection

• SQL Server connection

• Repository Architecture – Two or more Masters – Part 3

• Report of list of KMs in each Interface

• Connecting openLDAP

• How to call a Web Service that start an ODI Scenario and waits its complete execution

• Processing multiple Interface through single Package

• Multiple Files – Single Interface

• Generate Multiple Scenarios

• Sequence

• How to get a constant or pseudo-column from source mapping

• Lock Windows Layout

• Hide Unused Technologies

• Tab at the Top

• oracle.jdbc.V8Compatible

• Oracle to Flat file

• Scheduling using ODI Scheduler

• Exception – getobjectname schema

• How to create a Temp Table in ODI Interface (Yellow Interface)

• Printing report

• Step by step procedure to Read Excel (*.xls)

• Importing Knowledge Modules

• Creating Master and Work Repository

• Installation

• Repository Architecture – Just one Master – Part 2

• How to refresh ODI variables from file – Part 2 – Getting all lines, once at time

• How to refresh ODI variables from file – Part 1 – Just one value

• Repository Architecture – Just one Master – Part 1

• Welcome to ODI Experts, this is Cezar Santos.