July 31, 2010
by kdevendr
8 Comments
Categories: How to , Logic , ODI , Reports , Tips and Tricks
Tags: ODI , ODI Experts , odisqlunload , Sunopsis
Last week we have shown you the code for generating the Header and populate the same in OdiSqlUnload file , but the codes seems to be limited to the Database and then separate query needs to be created for each … Continue reading
July 30, 2010
by kdevendr
6 Comments
Categories: Common Errors , How to , Logic , ODI , Reports , Tips and Tricks
Tags: Managing Errors , ODI , ODI Errors , ODI Experts , Oracle Data Integrator , Sunopsis
Hi every one… In the last few posts we have shown how to display the SQL results in Operator , fetch the failed objects errors message in Package and various other techniques. Today we want to cover another small scripts … Continue reading
When we have multiple Interface, Variable and other ODI objects inside the Child Package and when such Child Package Fails we get the Error message ‘The scenario did not end properly’ and we need to look into the operator . … Continue reading
July 30, 2010
by kdevendr
6 Comments
Categories: Architecture , How to , Logic , ODI , Tips and Tricks
The below post shows the an easy method to create a SCD TYPE 3 functionality. Step 1 . Create a copy of the IKM Oracle Incremental Update and rename to IKM Oracle Incremental SCD Type 3 Step 2 . Add … Continue reading
July 30, 2010
by kdevendr
1 Comment
Categories: Architecture , How to , Logic , ODI , Tips and Tricks
Tags: ODI , Practice
Some of the best practice,we feel in day to day usage of ODI have been presented below. 1. Provide the Developer SNPS_LOGIN_WORK.XML and SNPS_LOGIN_SECURITY.XML, rather than providing the ODI_MASTER password. This way administrator can stop developer to play with repository … Continue reading
July 22, 2010
by Cezar Santos
9 Comments
Categories: Administration , Architecture , ODI , Tips and Tricks
Tags: ODI , ODI 11g , ODI Experts , ODI Studio , Oracle Data Integrator , Oracle Data Integrator 11g , Sunopsis
Hi Guys! It’s really a pleasure write this post… because Oracle Data Integrator 11g just arrives!!!!!!! Well, I’m not sure if you know but I’m an ODI enthusiastic (Did you notice it? 😀 ) and, because of that, I will tell … Continue reading