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
