ODIExperts.com

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

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

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

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

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

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

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

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

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

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

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

• Agent

• Alignment of objects in Package

• Asynchronous -Parallel Execution

• Automated ODI Export Import Scenarios

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

• AUTOMIZE ODI REPOSITORY EXPORTS

• Best practice of ODI

• Calling OdiSqlUnload using ODI Procedure with no hardcoded password

• Categorize Scenarios

• CDC CONSISTENT

• Changed Data Capture ( CDC )

• Connecting openLDAP

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

• Creating Interface for Single Source and Target

• Creating Master and Work Repository

• Creating ODI Procedure using SDK

• Creating Package using SDK

• Creating Permanent Interface based on Model Level

• Creating Temporary Interface using ODI SDK

• Datatypes – Creating what is missing for any technology

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

• Displaying SQL results in Operator

• Drivers Location in ODI 11g

• Dropping $ Tables

• Duplicate Multiple Objects in Package

• Error Records Log

• Exception – getobjectname schema

• Export – Import DWR to DWR having same Master Repository

• Export – Import DWR to EWR having same Master Rep

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

• Export DWR to EWR [ Common Master Rep ]

• Faster and Easiest way to design Interfaces

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

• Find the Value of the Variable in Operator ?

• First year of many…. Thank you Friends!

• Flow Control and Static Control

• Generate Column_name Header for OdiSqlUnload

• Generate Multiple Scenarios

• Get File Length and Header in Operator

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

• Getting one or several unknown files from a directory

• Handling the “ORDER BY” clause in an interface

• Hide Unused Technologies

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

• How to Change ODI Language (Idiom)

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

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

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

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

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

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

• Importing Knowledge Modules

• Information about the ODI Certification Exam

• Informix Connection

• Installation

• Installing ODI in Windows 7

• Interface Mapping Query

• Interface Parallel Execution – A new solution

• Interface with Union, Minus Operator using ODI SDK

• Internal ID

• Invisible Join

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

• Jython OS bug in Windows 7

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

• Jython’s Beginner Guide for ODI

• Killing session in ODI 11g

• KM FOR UNION BASED ON IKM SQL CNTRL APPEND

• LKM OdiSqlUnload(File) to Oracle ( SQLLDR )

• Lock Windows Layout

• Manual entry in ODI Driver List

• MINUS IN ODI

• Multiple Files – Single Interface

• New Author Arriving…

• ODI Certification – Approved

• ODI Expert and why there is no new posts…

• ODI SDK Setup and Config in Eclipse

• Oracle to Flat file

• oracle.jdbc.V8Compatible

• Ordered SQL

• Passing Values to ODI Variables in Packages/Scenarios

• Printing report

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

• Processing multiple Interface through single Package

• Querying in ODI

• Regenerate ODI Objects using OdiGenerateAllScen

• Removing Special character using Jython script

• Report of list of KMs in each Interface

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

• Repository Architecture – Just one Master – Part 1

• Repository Architecture – Just one Master – Part 2

• Repository Architecture – Two or more Masters – Part 3

• SCD Type 2

• SCD TYPE 3

• Scenario Report

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

• Scheduling using ODI Scheduler

• Security Module – Main concepts and use

• Send SQL by Email

• Sequence

• Shortcuts Keys

• Smart Search

• SNP_EXP_TXT – A “huge” table problem

• SQL Server connection

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

• Subscribers – An example of how to use

• Tab at the Top

• Things to be pride of….

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

• Topology Connection Detail

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

• Variable Detail Query

• Versioning

• Welcome to ODI Experts, this is Cezar Santos.

• Why Creating a separate schema in ODI?

• Writing SQL counts using Jython