Wooohooo… All my papers are accepted to OTN TOUR LAD 2014 (North America leg). I have filled out the permission form and if approved I will be speaking below events. It’s an honor to be accepted to this unique organization and proud of selected first Turkish Oracle Engineer ever.
Details of the event can be found here (Spanish). It will be great to meet with other ACE/ACED speakers as well as Oracle technologists of Latin America.
4th August : Panama, Panama
6th August : San Jose, Costa Rica
8th August : Mexico City, Mexico
11th August : Guatemala, Guatemala
13rd August : San Salvador, El Salvador
15-16th August : Bogota, Colombia
18-19th August : Quito, Ecuador (more…)
Actually my journey to Helsinki, Finland not started well. I have to leave my Zippo lighter’s inside at the German security, because I had a stop over at the Munich airport. And I starved for lighter in Helsinki, few people are smoking, nearly none of the shops are selling lighters and I was to camping next day. Luckily hotel’s matches helped me a lot, except begging 3 matches each time I go in the hotel.
Rest…? Rest of the trip and event was great.! As my friends Heli Helskyaho, Philippe Fierens, Jan Karremans, Lucas Jellema, Alex Nuijten and Brendan Tierney wrote their impressions (all are wonderful).
First credits goes to Heli Helskyaho & Ann Sjökvist for organising such a great event and accepting me as a speaker. Second credit goes to Oracle ACE Program (Vikki and Lillian), they are the one who were in charge that I was there (sponsorship of ACE Director budget). Finally, last credits goes to all speakers and attendees. This event cannot be without you. (more…)
I have been thinking of creating a brand new Knowledge Module which will make an Incremental Update without using any UPDATE/DELETE SQL statements, only with inserts to increase performance. Initially, I was thinking that there should be a second integration table, but when I started scrawling to figure out flow diagram and how Knowledge Module works, I realized that there is no need for a second integration table.
If you are using Oracle database which your target table existing, this Knowledge Module can fit your needs. Let me try to explain how it works;
1. Drops and Creates I$ flow table (as usual)
2. Inserts the missing records (new records on source) to I$ flow table (if INSERT_NEW_ROWS option is set to true).
3. Inserts the matching records (existing records on source) to I$ flow table (if UPDATE_EXISTING_ROWS option is set to true).
4. Inserts the non-matching records (deleted records on source) to I$ flow table (if NOT_DELETE_NON_EXISTING_ROWS option is set to true).
5. Wrap them up and truncate & insert target table from flow table and drop flow table (if DELETE_TEMPORARY_OBJECTS option is set to true).
6. Analyze target (if ANALYZE_TARGET option is set to true). (more…)
DBLink is the one of the most powerful attributes, if it is needed to load data from one Oracle database to other Oracle database especially when you are doing extraction. If you want to use DBLink, that you already implemented in Topology as “Instance / DBLink (Data Server)”, in a Knowledge Module in Oracle Data Integrator (ODI), there are not fancy options. (more…)
As some of you know, I will be attending to OUGF (Oracle User Group Finland) between 5-6th of June. Thanks to everybody who is in charge of paper selections especially Heli Helskyaho for the organization and Ann Sjökvist for the administration of the event. (more…)
Annual ODI Experts Panel of ODTUG will be placed tomorrow afternoon (for me night). We’ll try to answer all the questions about ODI 10G, 11G and 12c from the audiance. All the panelists are focused on ODI for different scopes. (more…)
It was a nice day of TROUG BI&DW 2014 full day meeting. Thanks for all attendees, speakers and everybody who paid attention to this event.
Here are some blog posts / articles about event impressions. (more…)
Save the date for third webinar of LAOUC. I will be talking about EDQ&OGG&ODI on Exadata for Perfection (click for registration) for LAOUC (Latin America Oracle User Community) on this Thursday (2nd April 5PM (BRT) – 8PM GMT – 10pm (GMT +2)).
I will be talking highlights about the powerful applications of Oracle’s Enterprise Data Quality, Golden Gate, Oracle Data Integrator and Oracle Exadata to produce a faster data warehouse preperation.
Join me for this webinar and let’s talk about the control ability of Oracle Data Integrator.
I will be attending a webinal panel which is 2nd annual ODTUG – Ask the Experts Panel : ODI on 29th April 2014 3PM EDT (10PM GMT+2).
Click to take a look at ODTUG Webinars, click to register the event.
Remember, you will be the one who will lead this panel with your questions.
Here’s a copy of what is written in ODTUG‘s webinar page.
Moderator : Jesus Villavicencio, Blue Stone – A Huron Consulting Group solution
Join ODTUG Expert’s Panel Webinar!
This is a live interactive panel similar to the ACE Lunch and Learn panels held at Kscope conferences. This innovative webinar is modeled after a call-in radio talk show. You will be able to chat a question to our organizer and if it is accepted you will have the option to verbally ask the question to our panel. Please be sure to have the proper equipment (headset and a quiet office) so that our panelists can clearly understand your question. You’ll also be able to participate in the discussion with the panel while they answer your question.
The following are some potential topics, but audience participation will shape the scope of the panel:
- What are the top features of ODI 12c and can they be used in a typical data warehouse implementation?
- Describe the migration from OWB to ODI 12c as it might occur in practice. Anything to watch out for?
- What are some examples of customizations that you have made in ODI and why?
- Interested in taking the ODI certification exam? We can talk about what was in the test, how to prepare for it, what to study, etc.
- Using ODI to improve the Hyperion Planning/Essbase capabilities.