Learn Testing! - Software Testing Life Cycle and Mobile Apps Testing.

Learn BI & Informatica! Fundamentals and concepts with real-time examples.
  • Home
  • Business Process
  • Data Modeling(DM)
  • DM & Database
  • DW & ETL
  • Software & Mobile Apps Testing
  • BI
  • Cloud Computing

You are here: Home Data Warehouse & ETL ETL Tools - Transformation Manager

2.4. Code Generators

Early ETL code generating tools simply provided a graphical design environment for programming languages such as C or COBOL. So me of these tools have now developed to provide full ETL design and run-time capabilities able to operate in a variety of architectures.

Generally, ETL code generating tools can handle more complex processing than their engine based counterparts. It is evident that, when compared to their engine based counterparts, code generators now eliminate the need for developers to maintain user-written routines to handle complex transformations in ETL workflows.


Code generators can produce compiled code to run on various platforms , or their own XML descriptions of transforms that can be interpreted in a variety of architectures. Although compiled code is generally accepted as the fastest of solutions, it also enables organizations to distribute processing across multiple platforms to optimize performance. Surprisingly, although interpretation of XML transform descriptions adds very little overhead, it can significantly speed up the design-time environment and is much easier to distribute within an organisation.

Although code generators usually offer visual development environments, they are sometimes not as easy to use as engine based tools , and can lengthen overall development times in direct comparisons with engine based tools. ETL tools often concentrate on a much more granular level and gain many friends amongst the more technical users, but lack the higher level management or domain specific view. Both management and technical users alike recognize the flexibility that code generators provide in fitting in to the client architecture and satisfying the many different transformation requirements (pull\push modes of operation, near real time transforms or bulk load). This flexibility empowers the user rather than enforcing a rigid architecture.

A significant advantage of code generation products is that since they can generally run on multiple platforms and processing can be distributed, it allows these products to be rolled out as required without the need for additional hardware and a major up-front investment.


Source: www.etlsolutions.com       Contact Info: info@etlsolutions.com

This Blog is an extension of LearnDataModeling.com and in here we post the latest articles and topics related to this site. Users can also post their questions and suggestions so that, it will be easier for us to answer the questions then and there!

Quick Links
» Business/Data Modeling Types
» Business Process Modeling
» Data Modeling Overview
» Steps to create a Data Model
» Supertype & Subtype
» Erwin Tutorial
» Dimensions
» Slowly Changing Dimensions
» Star Schema
» Data Warehouse Concepts
» ETL Concepts
» What is Business Intelligence?
Home     |     About Us     |     Contact Us     |     Testimonial     |     Articles     |     Blog

Copyright© LearnDataModeling.com. All Rights Reserved. Contact: Admin@LearnDataModeling.Com.