Scribd Logo
Upload

Welcome to Scribd!

  • 79 views

    Notes For Interviewing Ab Initio Developers

    Uploaded by

    amy_7
    The document provides notes for interviewing Ab Initio developers. It includes questions about formal training, working with the GDE, parallel processing techniques, understanding the EME repository, version control, private sandboxes, project structures, AIR commands, environment parameters, Unix, SQL, Cobol, DML, reformatting components, join components, phases, creating graphs from specs, housekeeping file types, and sample scenarios involving reading a flat file, joining with an Oracle table, grouping by customer, and updating a summary table.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    Notes For Interviewing Ab Initio Developers

    Uploaded by

    amy_7
    79 views3 pages
    The document provides notes for interviewing Ab Initio developers. It includes questions about formal training, working with the GDE, parallel processing techniques, understanding the EME repository, version control, private sandboxes, project structures, AIR commands, environment parameters, Unix, SQL, Cobol, DML, reformatting components, join components, phases, creating graphs from specs, housekeeping file types, and sample scenarios involving reading a flat file, joining with an Oracle table, grouping by customer, and updating a summary table.

    Original Description:

    Notes for Interviewing Ab Initio Developers

    Original Title

    Notes for Interviewing Ab Initio Developers

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides notes for interviewing Ab Initio developers. It includes questions about formal training, working with the GDE, parallel processing techniques, understanding the EME repository, version control, private sandboxes, project structures, AIR commands, environment parameters, Unix, SQL, Cobol, DML, reformatting components, join components, phases, creating graphs from specs, housekeeping file types, and sample scenarios involving reading a flat file, joining with an Oracle table, grouping by customer, and updating a summary table.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    79 views3 pages

    Notes For Interviewing Ab Initio Developers

    Uploaded by

    amy_7
    The document provides notes for interviewing Ab Initio developers. It includes questions about formal training, working with the GDE, parallel processing techniques, understanding the EME repository, version control, private sandboxes, project structures, AIR commands, environment parameters, Unix, SQL, Cobol, DML, reformatting components, join components, phases, creating graphs from specs, housekeeping file types, and sample scenarios involving reading a flat file, joining with an Oracle table, grouping by customer, and updating a summary table.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    You are on page 1of 3

    Notes for Interviewing Ab Initio developers

    1. Any formal Ab Initio training, e.g. basic two day course plus any others. Are they intending
    to become Ab Initio certified.

    2. Working with the GDE. Explain how to set up personal EME Datastore settings. (see my
    Installation Guide).

    3. Parallel processing. What techniques can be used.

    Partitioning (by key, by expression, round robin , percentage, range, load balance)
    Using MAX CORE in memory sorting.

    4. What do they understand about the EME.


    a) Central repository – storage of all Ab Initio components.
    b) Project parameters (variables)
    c) version control
    d) Check in and Check Out (once a graph is checked in from private sandbox it
    becomes version controlled by the EME and must be locked before working on – also
    it can be seen – and accessed or edited - by others in same project)
    Check Out – to get latest versions of graphs and parameters.
    e) Private sand box – personal development area.
    f) Project structure, private, shared and public project types.
    g) AIR commands (e.g. rm – remove, create-image (back up EME), ls – list files)
    h) What is the difference between stdenv (standard environment), local_environment
    and private project parameters. (stdenv is generic from AI, local is project wide, and
    private is generally for personal development area and can override other two)

    5. Unix skills

    6. SQL skills (not PLSQL or SQLPLUS)

    7. Cobol skills (copybooks etc.)

    8. What is DML (data manipulation language) – format of records.

    9. What is a Reformat component? (can add or delete fields, and change format of all fields, also
    can apply conditional business rules)

    10. What is a Join with DB component? (has a select statement to extract fields from a database
    which can be matched to input records, and also has transformation to add input and selected
    fields into new output).

    11. Explain Phases (where the dataflow can be split into sections where one process must finish
    before the next can start – e.g. dependencies)

    12. Can they create graphs from functional specs or do they require technical specs (e.g. pseudo
    code?) Can they write technical specs?

    13. Ab Initio housekeeping. What types of files are generally saved (MP – graphs, DML – dml
    layouts, XFR – transforms, RUN – KSH scripts, air-project parameters).
    14. Sample graph.

    Scenario: FIRST STEP:

    I have an flat input file from the mainframe which includes clientid, and several items of debt.
    I want to add the personal details for this customer from an Oracle table to this input data to
    produce a debt collection list in a flat file which cane be read by a spreadsheet program..
    What components should be used. Make assumptions about what is included in the Oracle
    table. Questions should be expected about the type of input file (e.g. ebcdic, cobol etc.)

    SECOND STEP:

    Now I would prefer to have just a total of the debt for each customer, rather than several rows
    for each customer in the file. What components should be added?

    THIRD STEP:

    I have an Oracle table which holds summary details for customers, with two fields
    CLIENT_ID and TOTAL_DEBT. How would I use the graph to update the table at the same
    time?

    You might also like