Pages

▼
Showing posts with label data transformation. Show all posts
Showing posts with label data transformation. Show all posts
17 March 2024

🧭Business Intelligence: Data Products (Part II: The Complexity Challenge)

›
Business Intelligence Series Creating data products within a data mesh resumes in "partitioning" a given set of inputs, outputs an...

🧭Business Intelligence: Data Products (Part I: A Lego Exercise)

›
Business Intelligence Series One can define a data product as the smallest unit of data-driven architecture that can be independently deploy...
10 March 2024

🏭📑Microsoft Fabric: Medallion Architecture [Notes]

›
Disclaimer: This is work in progress intended to consolidate information from various sources for learning purposes. For the latest informat...
20 March 2021

🧭Business Intelligence: New Technologies, Old Challenges (Part II - ETL vs. ELT)

›
  Data lakes and similar cloud-based repositories drove the requirement of loading the raw data before performing any transformations on the...
11 March 2021

💠🗒️Microsoft Azure: Azure Data Factory [Notes]

›
Microsoft Azure: Azure Data Factory (ADF) {definition} pay-per-use serverless cloud-based data in...
03 February 2021

📦Data Migrations (DM): Conceptualization (Part V: Data Extraction Layer)

›
ETL tools are ideal for extracting the needed data from the legacy system(s). They offer a considerable number of connectors to standard dat...
30 December 2020

🧊Data Warehousing: ETL (Part V: The Transform Subprocess)

›
As part of the ETL process , the Transform subprocess is responsible for bridging the gap between source and destination by leveraging SQL...
28 December 2020

🧊Data Warehousing: ETL (Part IV: The Load Subprocess)

›
As part of the ETL process , the Load subprocess is responsible for loading the data into the destination table(s). It covers in theory the ...
27 December 2020

🧊Data Warehousing: ETL (Part III: The Extract Subprocess)

›
  Data Warehousing Series As part of the ETL process with applicability to Data Warehousing, Data Migrations, Data Integrations or similar ...
23 March 2010

🕋Data Warehousing: Data Transformation (Definitions)

›
"A set of operations applied to source data before it can be stored in the destination, using Data Transformation Services (DTS). For e...
12 March 2010

🕋Data Warehousing: Pivot/Unpivot (Definitions)

›
"To rotate rows to columns, and columns to rows, in a cross-tabular data browser. Also refers to choosing dimensions from the set of av...
07 February 2010

🎡⌛SSIS: SQL Server to Oracle Data Export (Second Magic Class)

›
In a previous post I described the steps needed to be followed in order to export the data from SQL Server to Excel, this time I will descr...
2 comments:
23 January 2010

🧊🎡Data Warehousing: ETL (SSIS packages vs. SQL code)

›
I’ve been working with DTS (Data Transformation Services) packages for the past 7-8 years, finding SQL Server’s 2000 functionality pretty us...