ETL testing is a type of testing technique that requires human participation in order to test the extraction, transformation, and loading of data as it is transferred from source to target according to the given business requirements. Take a look at the block below, where an ETL tool is being used to transfer data from […]
Posts Tagged ‘Data Transformation’
ETL Vs ELT Differences
What is ETL? ETL stands for Extract, Transform, Load. This process is used to integrate data from multiple sources into a single destination, such as a data warehouse. The process involves extracting data from the source systems, transforming it into a format that can be used by the destination system, and then loading it into […]
Transform Your Business with Amazon DataZone
Amazon recently released a new data tool called DataZone, which allows companies to share, search, and discover data at scale across organizational boundaries. It offers many features such as the ability to search for published data, request access, collaborate with teams through data assets, manage and monitor data assets across projects, access analytics with a […]
Transform Your Data with Azure Data Factory
This blog will help you to understand the basic functionality of Azure Data Factory (ADF) and how powerful a tool it is when working with big data. Explore the basic architecture on ADF and get to know the components and services involved. A Quick Intro to Azure Data Factory & Its Key Features ADF is […]
Oracle BI Data Sync: How to Add a New Fact
Following my previous blog post on how to add a new Dimension to a Data Sync task, this post looks at how to add a Fact and perform a lookup on dimensions while loading the target fact table in a data warehouse using Data Sync. To refer to the blog post on adding a Dimension […]
Oracle BI Data Sync: How to Add a New Dimension
In this and the following post, I will cover the steps entailed in adding dimension and fact tasks in Oracle Data Sync. The latest releases of Data Sync included a few important features such as performing look-ups during an ETL job. So I intend to cover these best practices when adding new dimension and fact […]
Leveraging Value Added Data For Clinical Data Review In DMW
In my previous post, we discussed a simple scenario for reviewing clinical data cleanliness in Oracle’s Data Management Workbench. Today, we’ll discuss a similar process, although this scenario leverages value added data. Establishing value added data is another way to help the clinician to more quickly review the data and spot outliers and questionable data. […]
IBM SPSS Syntax -using Functions to perform Data Transformations
I recently finished another productive mentoring session exploring Data Transformations using SPSS Syntax. We had so much fun using some basic SPSS, I just had to share, so: Getting back to my Predictive startup example, we now have a new version of the quarterly hours file. This one includes a few new columns (“variables” to […]