NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

Performing Star Transformation

In this tutorial, you will learn how to use Advanced ETL Processor to perform star transformation. The package that you create takes data from Access Database, deduplicates ad sorts lookup data, and then inserts the result into a MS SQL Server fact table and lookup tables. In following lessons, the package will be expanded to demonstrate connections, package configurations, logging and error flow.

The best way to become acquainted with the new tools, controls and features available in Advanced ETL Processor is to use them. This tutorial walks you through Data transformation to create a complex Star transformation.

This tutorial is intended for users familiar with fundamental database operations, but who have limited exposure to the new features available in Advanced ETL Processor.

All our ETL tools have no limitations, that means you can load your data today and solve all the data quality problems right now.

One of the good things about Advanced ETL Processor that the trial has no limitations. There is no need to fill in any registration forms or to buy the software in advance.  That saved us a lot of time and we were able to load and  validate all our data when we needed it urgently.

John Parker.

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Australian Rugby Union
xerox
Databases we work with