ETL Preformance Tuning : Identification of Performance Bottleneck
Atul Singh
February 27, 2017
The goal of performance tuning is to optimize session performance by eliminating performance bottlenecks. To tune the performance of a sess...
Showing posts with label ETL. Show all posts
Showing posts with label ETL. Show all posts
Monday, February 27, 2017
Monday, February 6, 2017
Implementing Slowly Changing Dimension in ETL
Atul Singh
February 06, 2017
Dimension is a term in data management and data warehousing that refers to logical groupings of data such as geographical location, custome...
Monday, August 8, 2016
ETL Strategy #2
Atul Singh
August 08, 2016
Continued...... ETL Strategy #1 Delta from Sources extracted by Timestamp This project will use the Timestamp to capture the deltas f...
Monday, July 18, 2016
ETL Strategy #1
Atul Singh
July 18, 2016
The ETL Load will be designed to extract data from all the required Data Sources. The data to feed the Next Gen BI Database will have to b...
Tuesday, May 10, 2016
ETL Data Validation
Atul Singh
May 10, 2016
Organizations typically have “dirty data” that must be cleansed or scrubbed before being loaded into the data warehouse. In an ideal ...
Wednesday, April 13, 2016
ETL Code Review Checklist
Atul Singh
April 13, 2016
Guideline Design jobs for restartability/ if not designed then what is the reason ? Do not follow Sequential File s...
Tuesday, March 1, 2016
ETL Development Standards
Atul Singh
March 01, 2016
These development standards provide consistency in the artifacts the ETL developers create. This consistency improves testing, operationa...
Friday, February 26, 2016
Audit Strategy in ETL #2
Atul Singh
February 26, 2016
First - Audit Strategy in ETL #1 As shown in the above diagram, the audit services are dependent on source systems and target syste...
Audit Strategy in ETL #1
Atul Singh
February 26, 2016
The Audit service will provide simple measures on the ETL process: number of records input/output, number of rejected records, number of r...
