Posts Tagged ‘Data Transformation’

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 […]