2012 in review of Gurcan Orhan

The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog. Continue reading

My Presentation in NYOUG Webinar

If you want to download the presentation that I have performed in 7th December for NYOUG LI SIG, click here to download. Continue reading

Adding Functions to ODI

In most cases we (ETL developers) are stuck into doing something. Sometimes an analytic function helps, sometimes a function in database. But is there a way to use this function in a structured way that ODI can understand? Let’s try to find out. 🙂

Languages in Topology Manager help you leverage your languages that you can use in ODI. You can even add a new language (if you know and eager to type all commands). Continue reading

ODI Handling DQ

If you have some SQL scripts to send output to some business users, especially for data quality issues or other information, how would you handle this. In case you do not have a data quality tool for that.

Step 1 : Prepare your data quality scripts.
Step 2 : Put those scripts into files.
Step 3 : Prepare PL/SQL or ODI code to read contents of those files. Send this script to your database, insert output to an ERROR table.
Step 4 : Read ERROR table by ERROR_CODE and loop it from beginning to end.
Step 5 : Send e-mail for each script, attach the appropriate file and mention how many rows are generated in this ERROR_CODE.
Step 6 : Continue with Step 4. Continue reading

ODI Alert Mechanism

Today, I have read an article about recommendation about not using red lines (ko) in ODI packages. I just want to explain how I manage alert mechanism in ODI.
This is a sample package that I use in extraction phase. Continue reading

NYOUG (New York Oracle User Group) Long Island SIG Webinar

I’m invited to New York Oracle User Group (NYOUG) for the below webinar. To register the event, please use this link.

7 December 2012 Friday, 3:00pm – 4:00pm EST (20:00 – 21:00 GMT+2)

Best practices with Oracle Data Integrator (ODI), do you know how flexible ODI is ? By Gurcan Orhan – Oracle ACE Director
Join us for a Webinar on December 7
Space is limited.
Reserve your Webinar seat now at:
  Continue reading