Technology

  The Change Data Capture feature in the Oracle database platform is an integrated technology introduced in the 9i version. This new feature tracked and recorded all modifications in user tables in a database. These changes were then stored in ETL applications in the changed tables. The change data was processed and loaded into target data warehouses and other databases. The first model of the Oracle CDC technology worked on triggers set in the source tables that captured any changes as soon as they were made. However, this method was found to be too invasive by Database Administrators who were not very willing to work with it. Shortly thereafter, Oracle released a new form of Oracle CDC with the 10g version. It was different from the earlier model as the new one worked by leveraging the redo logs of the source database. This built-in tool for Oracle CDC was called Oracle Streams. This technology was a great improvement over the earlier one as it could detect and transfer change d

  Oracle database was launched commercially in 1991 and since then has been the leader in the data landscape of organizations. Oracle enables fast retrieval and storage of data and runs on various hardware and software operating systems. Oracle was one of the first databases to have supported GNU/LINUX. Given all these features, why do businesses migrate database Oracle to Snowflake ? Snowflake is a cloud-based data warehousing solution. It is independent of any “big data” software or existing database as it operates completely on the cloud. Rather, Snowflake uses a new SQL database engine with advanced technology that is way ahead when measured against other traditional databases. There are four steps in migrating a database from Oracle to Snowflake. The first is extracting data from the Oracle database to a CSV file by using the SQL Plus query tool. For mining incremental data, the SQL tool has to be run under specific conditions. The mined data has to be processed and form