Ab Initio Coach

Types of Partition Components In Ab Initio

The Abinitio Component organizer provides several partitioning components that divide data in different ways.Those are listed below 1.Function Partition 2.Hash Partition 3.Load Level partition 4.Percentage partition 5.Range Partition 6.Roundrobin partition 1.Function...

Types of parallelism in ab initio

In Ab Initio having three types of Parallelism. Parallel computing is the simultaneous performance of multiple operations.Ab Initio Uses the three main types of parallel computing:: 1.Component Level Parallelism 2.Pipeline Parallelism 3.Data Parallelism 1.Component...

sort component use before this components in ab initio

Some components required presorted data because they group adjacent records by a common key.if your data is not sorted,use the sort component before any of the following components: this is also increase performance tuning in ab initio. Aggregate Merge Dedup sorted Denormalize...

File Extensions in Abinitio

They are few file type extensions you must know in abinitio before you learn those are listed below .mp means graphs .dbc means database table files .dat means data files .dml means record format files(Data manipulation language) .xfr means transform function...

Runtime Status of graph in abinitio

the GDE(Graphical Development Environment) displays round colored indicators to show the status of each component during run time in abinitio white colour means unstarted the abinitio graph Green colour means running the abinitio graph Red colour means error...

Difference Between Aggregation And Rollup

Aggregation and Rollup, both are used to summarize the data. - Rollup is much better and convenient to use. - Rollup can perform some additional functionality, like input filtering and output filtering of records. - Aggregate does not display the intermediate...

ab initio dml sample

Here i am explaining with example data file and example of dml file in ab initio data will be like this 102,Damodar Reddy,M,Madanapalle,90000, 103,Prasad Kumar,M,Anantapur,50000, 104,Jim Tpt,M,Tirupati,40000, 105,Chandra Mouli,M,Bangalore,100000, 106,Mohan Narayana,M,Vizag,90000, 107,Mahesh...

Ab Initio Important Questions Frequently Asked by Companies [2016]

1)What is the difference between dbc and cfg? When do you use these two? .dbc file is Database configuration file. A file with a .dbc extension which provides the GDE with the information it needs to connect to a database. A configuration file contains the following...

Conditional DML With Example Explanation

Conditional DML is known as DML that is used as condition. we can write the conditional dml where header and trailer data accoured, data format is like this """ H,12/10/16,a.dat, D,121,damu,1000, D,131,raju,2000, D,141,reddy,3000, T,3, """ conditional dml...

Important String and Validation Functions in Ab Initio

In the Ab Initio few string and validation functions regularly using in the process of generate graphs. Important string functions string_split string_replace string_prefix string_index string_suffix string_rindex string_like string_substring string_length this...