Ab Initio Geek Interview Questions

Ab Initio Interview Questions, Abinitio Interview Questions and Answers For Experienced. Here Codingcompiler sharing a Real-time Abinitio scenario based interview questions. These advanced Abinitio questions will help you to crack your next Ab Initio job interview. All the best for your future and happy learning.

12) Explain what is Sort Component in Abinitio?The Sort Component in Abinitio re-orders the data. It comprises of two parameters “Key” and “Max-core”.

  • Key: It is one of the parameters for sort component which determines the collation order
  • Max-core: This parameter controls how often the sort component dumps data from memory to disk
  • 6) 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
  • 1 Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

    The first is Collection and the second one is the preparation of data. Of course, the collection is the first stage and preparation is the second in a cycle dealing with data processing. The first stage provides a baseline to the second and the success and simplicity of the first depends on how accurately the first has been accomplished. Preparation is mainly the manipulation of important data. The collection breaks data sets while Preparation joins them together.

    [ Check out: Open Source ETL Tools ]

    7) 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)
  • 9) 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.

  • Component parallelism: A graph with multiple processes executing simultaneously on separate data uses parallelism
  • Data parallelism: A graph that works with data divided into segments and operates on each segments respectively, uses data parallelism.
  • Pipeline parallelism: A graph that deals with multiple components executing simultaneously on the same data uses pipeline parallelism. Each component in the pipeline read continuously from the upstream components, processes data and writes to downstream components. Both components can operate in parallel.
  • 3 Why do you think data processing is important?

    The fact is data is generally collected from different sources. Thus, the same may vary largely in a number of terms. The fact is this data needs to be passed from various analyses and other processes before it is stored. This process is not as easy as it seems in most cases.

    Thus, processing matters. A lot of o time can be saved by processing the data to accomplish various tasks that largely matter. The dependency on the various factors for the reliable operation can also be avoided by to a good extent.

    What is a data processing cycle and what is its significance?

    Data often needs to be processed continuously and it is used at the same time. It is known as the data processing cycle. The same provides results that 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 a need for methods that are more reliable and advanced than existing approaches. The data cycle simply makes sure that complexity can be avoided up to the possible extent and without doing much.

    Abinitio Interview Question # 1

    Related Posts

    Leave a Reply

    Your email address will not be published. Required fields are marked *