Open in app

Sign In

Write

Sign In

Data Saint Consulting Inc
Data Saint Consulting Inc

216 Followers

Home

Lists

About

Pinned

3 levels of SQL expertise

What is the extent of your knowledge of SQL? Basic, intermediate or advanced? Basic: simple select queries with filtering, inner and left joins, aggregation, confident use of date functions, CASE statement, UNIONs etc., then state that you can create SQL queries to a basic level. Intermediate: CTEs and temp tables…

Sql

5 min read

3 levels of SQL expertise
3 levels of SQL expertise
Sql

5 min read


Pinned

How to load a fact table incrementally?

I want to move only Newly inserted or changed Rows from OLTP World into fact table. How can do I this by changing in code or schema Presented below? INSERT INTO Warehouse.dbo.factOrder (OrderDate, CustomerID, ProductID, OrderAmount) SELECT o.Date, c.CustomerID, p.ProductID, ISNULL(Amount,0) FROM Production.dbo.Orders o INNER JOIN Warehouse.dbo.dimCustomer c…

Data Engineering

2 min read

How to load a fact table incrementally?
How to load a fact table incrementally?
Data Engineering

2 min read


Pinned

How to Load Dimension Tables

The Basics: SQL MERGE, UPDATE and DELETE. These SQL features are the foundation for keeping data up-to-date in Hadoop, so let’s take a quick look at them. MERGE was standardized in SQL 2008 and is a powerful SQL statement that allows inserting, updating and deleting data in a single statement. MERGE makes it easy to keep two…

Data Engineering

11 min read

How to Load Dimension Tables
How to Load Dimension Tables
Data Engineering

11 min read


Pinned

Four SQL anti-patterns: Avoid them!

The following best practices provide guidance on avoiding query anti-patterns that impact performance in BigQuery. Self-joins Best practice: Avoid self-joins. Use a window (analytic) function instead. Typically, self-joins are used to compute row-dependent relationships. The result of using a self-join is that it potentially squares the number of output rows. This…

Sql

4 min read

Four SQL anti-patterns: Avoid them!
Four SQL anti-patterns: Avoid them!
Sql

4 min read


Pinned

Designing an ETL: Kimball’s 34 Subsystems

The Kimball Group has carefully restructured ETL best practices into 34 subsystems that represent the key ETL architecture components required in almost every dimensional data warehouse environment. The ETL process really has four major components: Extracting, Cleaning and Conforming, Delivering and Managing. …

Data Engineering

6 min read

Designing an ETL: Kimball’s 34 Subsystems
Designing an ETL: Kimball’s 34 Subsystems
Data Engineering

6 min read


2 days ago

Economic Growth Potential of Modern AI solution companies: Investment Perspective

এআইকে সফটওয়্যারের ভবিষ্যত হিসেবে দেখা হয়। এটির কারন সম্ভবত এআই অ্যাপ্লিকেশানগুলির User Experience: তাদের একটি ইন্টারফেস রয়েছে যেটা ডেটা বেবস্থাপনা করে এবং অন্যান্য সিস্টেমের সাথে একীভূত হয়। তবুও, সাধারনত, এআই অ্যাপ্লিকেশনগুলি আলাদা। তারা মূলত সিদ্ধান্ত নিতে সাহায্য করার জন্য ডেটা মডেলকে প্রশিক্ষণ দেওয়ার কাজ করে।

Artificial Intelligence

3 min read

Economic Growth Potential of Modern AI solution companies: Investment Perspective
Economic Growth Potential of Modern AI solution companies: Investment Perspective
Artificial Intelligence

3 min read


4 days ago

LLM এর জন্য কি সফটওয়্যার আর্কিটেকচার দরকার?

LLM এর এপিআই দিয়ে কল দিলেতো হয় আবার এখানে আর্কিটেকচার দরকার কেন? LLM রান করতে জিপিইউ দরকার হয়। এটা চালানো অনেক খরচের। তার উপর LLM গুলো টোকেন এর উপর টাকা নেয়। আপনার যা ওয়ার্ড নাম্বার আসবে আসলে তার থেকে ১.৫ গুণ করলে আপনি টোকেনের কাছাকাছি নাম্বার অনুমান করতে পারবেন। একটা চমতকার আর্কিটেকচার এই খরচ কমিয়ে আনতে পারে। তাহলে উপায় কি হতে পারে?

Software Development

3 min read

LLM এর জন্য কি সফটওয়্যার আর্কিটেকচার দরকার?
LLM এর জন্য কি সফটওয়্যার আর্কিটেকচার দরকার?
Software Development

3 min read


Sep 17

ETL: A Human Story

In a bustling tech company, Sarah is the formidable boss of the data engineering department. She’s known for her unyielding expectations and an icy demeanour that keeps everyone at arm’s length. Alex, a brilliant ETL specialist, joins her team with dreams of making a mark in the world of data. …

Storytelling

4 min read

ETL: A Human Story
ETL: A Human Story
Storytelling

4 min read


Aug 6

“Chronicles of the Data Labyrinth: Trials of a Naive Developer”

A Whisper in the Digital Wind In the heart of Silicon Valley, where innovation and ambition converged, a digital whisper found its way into the inbox of a young data developer named Alex. An email, innocuous yet intriguing, extended an invitation to a world of untapped potential — an ETL…

Software Development

3 min read

“Chronicles of the Data Labyrinth: Trials of a Naive Data Developer”
“Chronicles of the Data Labyrinth: Trials of a Naive Data Developer”
Software Development

3 min read


Jul 30

ETL Troubleshooting: Dealing with Errors in the Source System

The choice of source systems for an ETL (Extract, Transform, Load) process depends on the specific requirements and nature of the data you want to integrate and analyze. …

Etl

6 min read

ETL Troubleshooting: Dealing with Errors in the Source System
ETL Troubleshooting: Dealing with Errors in the Source System
Etl

6 min read

Data Saint Consulting Inc

Data Saint Consulting Inc

216 Followers

For Consultation services regarding Data Engineering and Analytics: datasaintconsulting@ gmail.com

Following
  • Feng Li

    Feng Li

  • Amna Fayyaz

    Amna Fayyaz

  • Rakesh singhania

    Rakesh singhania

  • DataStax

    DataStax

  • DP6 Team

    DP6 Team

See all (1,238)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech

Teams