Mention what is Abinitio?
“Abinitio” is a latin word meaning “from the beginning.” Abinitio is a tool used to extract, transform and load data. It is also used for data analysis, data manipulation, batch processing, and graphical user interface based parallel processing.
Explain what is the architecture of Abinitio?
Architecture of Abinitio includes
- GDE (Graphical Development Environment)
- Co-operating System
- Enterprise meta-environment (EME)
- Conduct-IT
Mention what is the role of Co-operating system in Abinitio?
The Abinitio co-operating system provide features like
- Manage and run Abinitio graph and control the ETL processes
- Provide Ab initio extensions to the operating system
- ETL processes monitoring and debugging
- Meta-data management and interaction with the EME
Explain what does dependency analysis mean in Abinitio?
In Ab initio, dependency analysis is a process through which the EME examines a project entirely and traces how data is transferred and transformed- from component-to-component, field-by-field, within and between graphs.
Explain how Abinitio EME is segregated?
Abinition is logically divided into two segments
- Data Integration Portion
- User Interface ( Access to the meta-data information)
Mention how can you connect EME to Abinitio Server?
To connect with Ab initio Server, there are several ways like
- Set AB_AIR_ROOT
- Login to EME web interface- http://serverhost:[serverport]/abinitio
- Through GDE, you can connect to EME data-store
- Through air-command
List out the file extensions used in Abinitio?
The file extensions used in Abinitio are
- .mp: It stores Ab initio graph or graph component
- .mpc: Custom component or program
- .mdc: Dataset or custom data-set component
- .dml: Data manipulation language file or record type definition
- .xfr: Transform function file
- .dat: Data file (multifile or serial file)
Mention what information does a .dbc file extension provides to connect to the database?
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
Explain how you can run a graph infinitely in Ab initio?
To execute graph infinitely, the graph end script should call the .ksh file of the graph. Therefore, if the graph name is abc.mp then in the end script of the graph it should call to abc.ksh. This will run the graph for infinitely.
Mention what the difference between “Look-up” file and “Look is up” in Abinitio?
Lookup file defines one or more serial file (Flat Files); it is a physical file where the data for the Look-up is stored. While Look-up is the component of abinitio graph, where we can save data and retrieve it by using a key parameter.
