Simple idea of how to use openESB and scheduled invocation of ETL process and store log data in database. Best ETL method is “Stagging” that uses “stagging table”. It simply transfers a bunch of rows from one db to another firstly to the middle buffer table and then to the target one. No delays, no empty tables, and data always fresh and ready for processing :)

Posted

There was amazing www service from SUN, full of super tutorials. There were many, many great guys posting there screencast, it was mediacast.sun.com. After oracle takeover SUN all media disappeared, and there is better, they are lost!

Important Notification for Mediacast users.

Please be advised that Mediacast (http://mediacast.sun.com) will be decommissioned on July 29, 2010. Between now and July 29, 2010, users must move their content off http://mediacast.sun.com and remove or update any links to content that is posted there. Content not moved by July 29, 2010 will be lost.

Posted