Ab initio components

  In this section we are going to discuss about some basic and important component in Ab initio

1.     Dataset components

2.     Departition

3.     Partition

4.     Sort

5.     Transform

6.     Miscellaneous

7.     Validate

Dataset Components:

  Dataset components represent data records or act upon data records as follows:

• INPUT FILE represents data records read as input to a graph from one or more serial files or from a multifile                 

• INPUT TABLE unloads data records from a database into an Ab Initio graph, allowing you to specify as the source either a database table, or an SQL statement that selects data records from one or more tables.                      

• INTERMEDIATE FILE represents one or more serial files or a multifile of intermediate results that a graph writes during execution, and saves for your review after execution.                     

• LOOK UP: represents one or more serial files or a multifile of data records small enough to be held in main memory, letting a transform function retrieve records much more quickly than it could retrieve them if they were stored on disk.

                                    

• OUTPUT FILE represents data records written as output from a graph into one or multiple serial files or a multifile.

                                     

• OUTPUT TABLE loads data records from a graph into a database, letting you specify the records' destination either directly as a single database table, or through an SQL statement that inserts data records into one or more tables.

                                                          

• READ MULTIPLE FILES sequentially reads from a list of input files.

                                       

• WRITE MULTIPLE FILES writes records to a set of output files.