Pages

▼
Showing posts with label data flows. Show all posts
Showing posts with label data flows. Show all posts
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...
27 November 2020

🧊Data Warehousing: ETL (Part II: An Introduction)

›
  ETL (Extract, Transform, Load) processes, technologies or tools are about extracting data from one or more data sources via a set of queri...
04 May 2019

🧊Data Warehousing: Architecture (Part I: Push vs. Pull)

›
In data integrations, data migrations and data warehousing there is the need to move data between two or more systems. In the simplest scena...
29 April 2019

🗄️Data Management: Data Integration (Part I: From Disintegration to Integration)

›
Data Management Series No matter how tight the integration between the various systems or processes there will be always gaps that need to ...
16 January 2017

⛏️Data Management: Data Flow (Definitions)

›
"The sequence in which data transfer, use, and transformation are performed during the execution of a computer program."  (IEEE,...
13 February 2014

🕸Systems Engineering: System Dynamics (Definitions)

›
"A field of study that includes a methodology for constructing computer simulation models to achieve better under-standing of social an...
15 February 2013

🔦Process Management: Process model (Definitions)

›
"A formal, detailed description of a process that covers policies, activities, work products, roles, and responsibilities. Typically co...
14 August 2011

📈Graphical Representation: Data Flow Diagram (Definitions)

›
"A diagram that shows the data flows in an organization, including sources of data, where data are stored, and processes that transform...
15 February 2010

🕋Data Warehousing: Control Flow (Definitions)

›
"A component of a SQL Server Integration Services package that controls the flow of tasks within the package. The high-level workflow o...
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...
31 December 2007

🏗️Software Engineering: Architecture (Just the Quotes)

›
"The term architecture is used here to describe the attributes of a system as seen by the programmer, i.e., the conceptual structur...