March 28, 2010
by kdevendr
3 Comments
Categories: Administration , Architecture , How to , ODI , Technology , Tips and Tricks
Tags: EWR , Execution Mode , Export , Import , Master Repository , ODI Solution , Scenarion
This post explain the process of Exporting Scenarios from DWR to EWR . As Cezar have suggested in previous post of how it is important to have one single DWR ( Developer Work Repository) and multiple EWR [ Execution Work … Continue reading
March 28, 2010
by kdevendr
0 comments
Categories: ODI , Reports , Tips and Tricks
Tags: Reports , scenario , session
This below query provide details about each scenario and its associated session run details in the operator . This enables to get details about each run whether it was successful , record processed , inserted and updated and duration in … Continue reading
March 27, 2010
by kdevendr
4 Comments
Categories: ODI , Tips and Tricks
Tags: Asynchronous , parallel , scenarios
In ODI interface can be called parallel through using odistartscen. Step 1 – Create Scenarios of the Interface. Step 2 . In the package ,drag the odistartscen and provide the following details as shown below. [ Note ;- Version = … Continue reading
March 23, 2010
by kdevendr
2 Comments
Categories: How to , ODI , Tips and Tricks
Tags: $ TABLES , LOGS , ODIPURGELOG , PURGE LOGS
There are many development environment where the $ tables created in the ODI work schema are not removed at proper interval .As the development grows the more number of $ tables grow especially in the environment where dynamic $ tables … Continue reading
March 23, 2010
by kdevendr
1 Comment
Categories: How to , Knowledge Modules , Logic , ODI , Tips and Tricks
Tags: IKM SQL CONTROL APPEND , KM , UNION
This KM is do UNION in ODI which created based on IKM SQL Control Append and support Flow control too and is based on the full outer join concept Map the column in this format NVL( <SOURCE1.COLUMN1 , SOURCE2.COLUMN1> NVL(<SOURCE1.COLUMN2,SOURCE2.COLUMN2> … Continue reading
March 20, 2010
by kdevendr
2 Comments
Categories: Common Errors , How to , Logic , ODI , ODI Bug , Tips and Tricks
Tags: installation , setup , windows 7
There seems to be some forum threads with installing ODI in windows 7 Edition . I would like to throw some light and tweaks to make it work. ODI doesn’t support windows 7 since it checks for Windows version before … Continue reading
March 20, 2010
by kdevendr
2 Comments
Categories: Common Errors , How to , ODI , ODI Bug , Tips and Tricks
Tags: ODI sql , query
There is an easy way of writing query inside ODI Right click on the any datastore of the required technology on which you wish to run the query and select Data. Click on the SQL (?) on the Top Left … Continue reading
March 14, 2010
by Cezar Santos
56 Comments
Categories: How to , Logic , ODI , Tips and Tricks
Tags: CDC , Data Capture , JKM , Journalizing , ODI , Simple , Simple CDC
Changed Data Capture as the term implies is used to capture the data that is inserted, updated and deleted at the source side and replicating the same at the target. ODI have a Journalizing KM to do the required implementation … Continue reading
March 14, 2010
by kdevendr
49 Comments
Categories: Architecture , How to , ODI
Tags: Agent , agent scheduling , Load Balancing
This post describes how to create an single and multiple agent and how to start an scheduler agent and other information. Step 1 – Start the Agent.bat or Agent.sh under oracledi/bin Step 2 – Topology Manager – > Physical Architecture … Continue reading
This post came from curiosity to try some thing and digging into the code of the ODI java and XML and Please dont try this in your Production box. This is completely experimental . When we don’t have latest driver … Continue reading