Extract Load and Transform (ELT)

Extract Load and Transform (ELT)

Data Transformation

ProblemWhat problem is the pattern looking to solve How do we leverage the compute power of our target data repository to transform data. ContextThe situation in which this pattern applies TBD SolutionA generalised design which can be applied to solve the problem...
Extract, Transform and Load (ETL)

Extract, Transform and Load (ETL)

Data Transformation

ProblemWhat problem is the pattern looking to solve How do we change data as we move it between data repositories. ContextThe situation in which this pattern applies TBD SolutionA generalised design which can be applied to solve the problem given the context ImpactThe...
Change Data Capture (CDC) – Log Mining

Change Data Capture (CDC) – Log Mining

Data Collection

ProblemWhat problem is the pattern looking to solve How do we capture all data changes in a source applications database as they happen, so that any changes in records can be easily collected, loaded and retained in another data repository. ContextThe situation in...
Change Data Capture (CDC)

Change Data Capture (CDC)

Data Collection

ProblemWhat problem is the pattern looking to solve How do we capture all data changes in a source application as they happen, so that any changes in records can be easily collected, loaded and retained in another data repository. ContextThe situation in which this...