Saturday 29 October 2011

Transform Components at a glance

Reformat Component : Each input record is used to create one output record(One - to - One).

                                    Ex: input records - 25 , output records will be 25

Rollup Component : A group of input records is used to create one summary record(Many - to - One).

                                    Ex: input records - 25 , output records will be 5

Normalize Component : Each input record is used to create a group of output records(One - to - Many).

                                    Ex: input records - 25 , output records will be 30

Scan Component : A group of input records is used to create a group of output records(Many - to - Many).

                                    Ex: input records - 25 , output records will be 25

Graph Building Checklist

Steps for building a new graph:


  • Understand the business requirements
  • Identify the data sources that will be required
  • Know your data
  • Break down the requirements into logical steps
  • Configure the data source components
  • Configure the data target components
  • Add and test components in logical groups
  • Continue until all targets are connected
  • Review the design
  • Arrange and document the graph to make it easy to read.


Introduction - Ab initio


The Ab Initio software is a fourth generation powerful data analysis, batch processing, data manipulation graphical user interface (GUI)-based parallel processing tool which is commonly used to extract, transform and load (ETL) data.

The Ab Initio software is a suite of products which together provide a platform for data processing applications. The Core Ab Initio products are:
This section will include useful tips about Ab Initio usage, best practices guidelines and some optimization methods.

Sunday 29 May 2011

Benefits

  • Graphical programming boosts productivity
  • Applications built graphically are easy to understand and explain.
  • Applications are portable to many platforms.
  • The Co>operating system delivers high performance and unlimited scalability.
  • The Co>operating system ensures robust execution.