Posts Published

• 11g Oracle Data Integrator – Standalone Agent but, and about the Windows Service???
• 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
• Find the Value of the Variable in Operator ?
• First year of many…. Thank you Friends!
• Flow Control and Static Control
• Generate All Scenario for a Particular Project using ODI SDK
• 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 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
• 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
• ODI SDK Setup and Config in Eclipse
• Oracle to Flat file
• oracle.jdbc.V8Compatible
• Ordered SQL
• 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