Ab Initio ETL and Data Processing

With serial input and output through Reformat, different stages can work simultaneously - input reads, Reformat processes, output writes. This is pipeline parallelism where data flows through stages like a pipeline. No data parallelism (same data on different flows) or component parallelism (multiple instances).

m_dump displays the contents of a multi-file in Ab Initio. m_ls lists, m_expand expands, m_mkfs creates filesystem. The 'dump' command is standard for displaying file contents.

To view last 5 records of 20, start from record 16 (20-5+1=16). m_dump with -start 16 displays from record 16 to end (records 16-20). Option A shows all 20, C shows all, D has wrong syntax.

Cobol-to-dml is the utility that converts COBOL copybook definitions into DML (Data Manipulation Language) record format. The other utilities are for different purposes - ab_expression_info for expressions, dml-to-wsdl for WSDL conversion.

This question asks which statement about conditional DML is FALSE. The correct answer is D because conditional fields CANNOT share delimiters with the record - each conditional field must have its own delimiter specification. Options A, B, C, and E are all true statements about conditional DML fields in Ab Initio.

Options A, B, and C show valid SORT key specifier syntax using the {} notation with field names and optional sorting directions. Option D uses 'desc cust_id' which is NOT valid Ab Initio SORT component syntax - the correct format would be '{cust_id descending}' within braces, not as a separate keyword before the field name.

The Reformat component in Ab Initio is specifically designed to transform data structure - it can add fields, drop fields, or change field layouts. Sort only orders data, Join combines data, and Redefine Format changes DML interpretation. For adding/dropping fields, Reformat is the correct choice.

Redefine Format changes how the system interprets the data's DML structure without altering the actual data values. Reformat modifies the data structure and content, Sort only orders rows, and Join combines data. When you want to change the DML definition but keep the data itself unchanged, Redefine Format is the correct component.

In Ab Initio DML, valid types include string, decimal, integer, date, datetime, and others. 'char' is NOT a valid DML type in Ab Initio - the correct type for character data is 'string' (or 'vector(string)' for arrays). Char might be confused with SQL character types, but Ab Initio DML uses 'string' instead.

Date and Datetime types in Ab Initio are stored in binary form for efficiency in calculations and comparisons. While integers are also stored in binary, the question specifically asks about types known for binary storage of temporal data. Decimal stores as packed decimal, and string stores as character data. Date/Datetime is the best answer for binary-encoded temporal data.

Standard join types in database systems include Inner Join, Outer Join, and Self Join. Explicit refers to join syntax style rather than a specific logical join type.

In Ab Initio's Reformat component, the 'transform' parameter is the most critical because it contains the transformation logic that defines how each input record is converted to an output record. The 'count' parameter is optional (specifies number of output ports), while 'select' and 'ramp' are not core Reformat parameters.

Sort requires a key for ordering records. Rollup needs a key to group records for aggregation. Join requires keys from both inputs to match records. Reformat, however, operates on individual records without requiring any key - it transforms each record independently based on the transform logic.

Rollup aggregates multiple input records into fewer output records based on a key. For example, if you have 100 sales records and rollup by product, you might get 10 output records (one per product). Sort maintains the same record count. Reformat and Redefine Format also preserve record count - they transform structure, not quantity.

The SQL LIKE operator is used for pattern matching in string columns. The percent sign (%) is a wildcard that matches zero or more characters. To find values starting with 'a', use 'a%' (matches 'a' followed by anything). Option A ('%a') finds values ending with 'a', option B uses equality instead of pattern matching, and option D has incorrect wildcard placement.

Cognos BI has multiple components: Analysis Studio is designed for multidimensional analysis and exploration of OLAP data, making it the correct choice for multidimensional reporting. Query Studio is for simple ad-hoc queries, Report Studio for formatted reports, Event Studio for event-based alerts, and Metric Studio for performance scorecards.

The DISTINCT keyword in SQL eliminates duplicate rows from query results, returning only unique values. Option A (DIFFERENT) is not valid SQL syntax. UNIQUE is a constraint, not a query keyword for filtering duplicates. ALL returns all rows including duplicates (default behavior).