Posts Published

• 11g Oracle Data Integrator – Part 1/11g – First Screen
• 11g Oracle Data Integrator – Creating Repositories – Part 2/11g
• 11g Oracle Data Integrator – Graphical User Interface – Part 3/11g
• Agent
• Alignment of objects in Package
• Asynchronous -Parallel Execution
• Automated ODI Export Import Scenarios
• AUTOMIZE ODI REPOSITORY EXPORTS
• Best practice of ODI
• Calling OdiSqlUnload using ODI Procedure with no hardcoded password
• Categorize Scenarios
• Changed Data Capture ( CDC )
• Connecting openLDAP
• Context, Logical And Physical Schema – How does it work?
• Creating Master and Work Repository
• Data types – Creating what is missing for any technology
• Displaying SQL results in Operator
• 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 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 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
• 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
• 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
• Internal ID
• Invisible Join
• IS_NUMBER (and IS_CHAR) at Oracle? A workaround…
• Jython OS bug in Windows 7
• 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
• Oracle to Flat file
• oracle.jdbc.V8Compatible
• 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
• Scheduling using ODI Scheduler
• 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
• Topology – Data Server – Which user should be used to connect?
• Topology Connection Detail
• Variable Detail Query
• Versioning
• Welcome to ODI Experts, this is Cezar Santos.
• Why Creating a separate schema in ODI?
• Writing SQL counts using Jython