Archive for the ‘Tutorial’ Category

  In the part one we looked at an overview of the data conversion process, in parts two and three we looked at using Microsoft Access to facilitate the transformation step in the ETL (Extract Transform and Load) Process. In addition to transformation Access provides a lot of useful functionality to assist in the important […]

Wednesday, October 5th, 2011 at 12:59 | 0 comments

  In this part we look in more detail at how to perform some specific transformation processes using Microsoft Access. Advanced transformation Topics. The database in this example was relatively simple and you could argue that a single query written on the load file could complete all the transformation and formatting changes required. However breaking […]

Wednesday, September 28th, 2011 at 21:52 | 0 comments

  In part one we looked at the general process of data conversion within the context of an SAP implementation. In part two we look at the use of Microsoft Access to facilitate data conversions and set up a sample conversion database Transform and Reconciliation There are two major tasks during data conversion that may […]

Wednesday, September 21st, 2011 at 14:35 | 3 comments
Get Adobe Flash playerPlugin by wpburn.com wordpress themes
TOP