Data Sourcing : Questions to new Data Sources when building pipelinesIt is very common practice in a data pipeline or ETL projects to get to know all the details about the source before any development…Dec 7, 2020Dec 7, 2020
Query Optimization: Rewriting UPDATE statementsQuery optimization is the most common practice when it comes to database performance improvement. Most of the common optimization…Dec 5, 2020Dec 5, 2020
SQL or Programming (vs) Hybrid Approach: How we reduced processing time from 24 hours to 24 minutesThere is a constant tug-of-war when it comes to extracting insights out of data between SQL and Programming languages. Even for simple…Dec 5, 2020Dec 5, 2020