what is ETL? ETL is a process that extracts the data from different source systems, then transforms the data (like applying calculations, concatenations, etc.), and finally loads the data into the Data Warehouse system. The full form of ETL is Extract, Transform, and Load. What is a data warehouse (DW)? A Data Warehouse (DW) is […]
Posts Tagged ‘datawarehouse’
Feature of Snowflake: Time Travel
Snowflake: Snowflake’s data cloud is powered by advanced data platform provided as software as a service. Snowflake enables data storage, processing, […]
Time Travel with Snowflake and BigQuery
Hello friends, I am back with another interesting topic called “time travel.” I believe many of you wish you could go back in time and fix something. The idea of time travel was made possible in the fictional world of movies and books, including Aditya 369 (released during my teens), recent Marvel movies, and Tenet. […]
Getting to know Oracle Data Integrator (ODI)
As an avid user of IBM DataStage for over 8 years I was recently on a client engagement where I had to use Oracle’s Oracle Data Integrator (ODI). At first I was disappointed as I was out of my confront zone. But after a week or two I was very surprised how quickly I was […]
Change Data Capture: Capabilities, UseCases and Offerings: Part 2
The post is the 2nd in the series which covers capabilities, use cases and product offerings for change data capture technology. The critical capabilities which are expected in a CDC tool Selective data replication and synchronization is a capability to synchronize data between multiple databases. It usually supports high volume and mission critical scenarios. An […]