Ab Initio Pro - your personal ab initio learning guide

Indexed compressed flat file or ICFF can be considered as a special kind of lookup file which can store large volumes of data without compromising quick access to individual records. Common lookup files have a limit to the amount of data one can store, which is not the limitation of ICFF. Other important features, as gathered from help: ICFFs present advantages in a number of categories: * Requires much less disk storage — as name suggests, ICFFs store compressed data in flat files without the overheads associated with a DBMS, hence requiring much less disk storage capacity than databases — on the order of 10 times less. * Requires much less memory at one time — as ICFFs organize data in discrete blocks, only a small portion of the data needs to be loaded in memory at any one time. * Comparatively much faster — ICFFs allow us to create successive generations of updated information without any pause in processing which significantly reduces the time between a transaction taking...

1. Explain what is de-partition in Abinitio ? (Abinitio Interview Questions) Answer: De-partition is done in order to read data from multiple flow or operations and are used to re-join data records from different flows. There are several de-partition components available which includes Gather, Merge, Interleave, and Concatenation. Abinitio Interview Questions 2. Explain what is SANDBOX ? Answer: A SANDBOX is referred for the collection of graphs and related files that are saved in a single directory tree and behaves as a group for the purposes of navigation, version control, and migration. 3. What do you mean by the overflow errors ? Answer: While processing data, calculations which are bulky are often there and it is not always necessary that they fit the memory allocated for them. In case a character of more than 8-bits is stored there, this errors results simply. 4. What is data encoding ? Answer: Data needs...

1. Mention what information does a .dbc file extension provides to connect to the database ? (Ab Initio Scenario Based Interview Questions) Answer: The .dbc extension provides the GDE with the information to connect with the database are • Name and version number of the data-base to which you want to connect • Name of the computer on which the data-base instance or server to which you want to connect runs, or on which the database remote access software is installed • Name of the server, database instance or provider to which you want to link. Ab Initio Scenario Based Interview Questions 2. What is a data processing cycle and what is its significance ? Answer: Data often needs to be processed continuously and it is used at the same time. It is known as data processing cycle. The same provide results which are quick or may take extra time depending on the type, size and nature of data. This is boosting the complexity in this approach and thus there is...