Synchronizing Objects in Oracle Warehouse Builder
Synchronizing objects
We created tables, dimensions, and a cube; and new tables were automatically created for each dimension and cube. We then created mappings to...
Configuring a MySQL linked server on SQL Server 2008
Linking servers provides an elegant solution when you are faced with running queries against databases on distributed servers or looking at your distributed assets...
MySQL Data Transfer using Sql Server Integration Services (SSIS)
There are a large number of posts on various difficulties experienced while transferring data from MySQL using Microsoft SQL Server Integration Services. While the...
Creating External Tables in your Oracle 10g/11g Database
In this two-part article by Hector R. Madrid, we will learn about the External Tables in Oracle 10g/11g Database. When working in data warehouse environments, the Extraction—Transformation—Loading (ETL) cycle...
Must Read in Cloud & Networking
Top life hacks for prepping for your IT certification exam
I remember deciding to pursue my first IT certification, the CompTIA A+. I had signed up for a class that lasted one week, per...
Must Read in Data
Learn Transformers for Natural Language Processing with Denis Rothman
Key takeaways
The transformer architecture has proved to be revolutionary in outperforming the classical RNN and CNN models in use today.
Artificial intelligence is...
