Blogs by

Siji Mathew

ORACLE CDC Whenever a change is made in the source database, the information is written into database logs first and later, when it is convenient for the database, in the real database file itself. This

Use the below regular expression function to select onlt the alphanumeric data from the source match_regex(SQL_Latest_Employees.HRRA01_LAST_N , ‘[0-9A-Za-z]*’,NULL ) = 1

Problem: While developing the SCD2 data flow using the Teradata tables a lock happened between the updates and the reads of the Teradata target table and the job was hanging for long time. SCD2 The