I85PREP
⌘ K
Informatica PowerCenter Developer Specialist study materials
Informatica PowerCenter Developer Specialist study resources

Informatica PowerCenter Developer Specialist practice questions

One question at a time. Build your Informatica PowerCenter Developer Specialist understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Repository Objects, Source and Target Definitions

Within PowerCenter Designer, which tool is used to create, import, and edit source definitions?

  1. Repository Manager
  2. Target Designer
  3. Source Analyzer Correct answer.
  4. Mapping Designer

Explanation

Source Analyzer is the Designer tool where source definitions are built, either by importing metadata from a relational source or flat file, or by entering the columns manually. Target Designer handles target definitions, Mapping Designer assembles mappings from sources through transformations to targets, and Repository Manager administers folders and repository objects rather than column metadata.

Question 2Repository Objects, Source and Target Definitions

What does the PowerCenter repository store for a relational source or target definition?

  1. The extracted rows last loaded from that table
  2. Metadata such as table name, columns, datatypes, and precision Correct answer.
  3. The session log entries written during the last workflow run
  4. The database execution plans generated by the Integration Service

Explanation

The repository is a metadata database: for each definition it keeps the object name, column names, datatypes, precision, scale, key type, and the database type it was imported from. Actual row data is read by the Integration Service at run time and is never persisted in the repository tables.

Question 3Repository Objects, Source and Target Definitions

Which set of attributes belongs to the column-level metadata of a relational source definition?

  1. Target load type, commit interval, and error threshold
  2. Sorted ports, select distinct, and source filter
  3. Column name, datatype, precision, scale, and key type Correct answer.
  4. Database connection name, code page, and owner name

Explanation

Each port in a source definition carries a column name, a PowerCenter datatype, precision and scale, and a key type such as primary key or foreign key. The other lists mix in Source Qualifier options (sorted ports, distinct, filter), session properties (load type, commit interval), and table-level definition properties (connection, code page, owner).

Question 4Repository Objects, Source and Target Definitions

A source table in Oracle has gained two new columns, and the definition stored in the repository does not contain them. Which Source Analyzer feature compares the stored definition with the database and updates it in place?

  1. Running the Debugger against the mapping that reads the source
  2. Adding the missing ports to each affected mapping by hand
  3. Synchronizing the source definition with the database Correct answer.
  4. Copying the table into a new folder and re-importing it under another name

Explanation

The Synchronize option compares the stored source definition against the current structure returned by the database connection and reports columns that were added or removed, letting you apply the differences without deleting and rebuilding the object. Manual re-import under a different name would create a second, conflicting object rather than reconcile the existing one.

Question 5Repository Objects, Source and Target Definitions

A developer intends to drop a column from a shared source definition. Which Repository Manager feature shows every mapping, mapplet, and session that would be affected before the change is made?

  1. Add to Deployment Group
  2. Purge Version
  3. Compare Objects
  4. View Dependencies Correct answer.

Explanation

View Dependencies performs impact analysis across the repository, listing the objects that use the selected object and the objects it depends on, even across folders. That lets the developer judge the blast radius of a metadata change before saving it, instead of discovering broken mappings afterwards.

Question 6Repository Objects, Source and Target Definitions

Which statement about source and target definitions in a PowerCenter folder is correct?

  1. They must be copied once per mapping that reads the same table
  2. They are always reusable, so one definition can serve many mappings Correct answer.
  3. They become reusable only after being added to a mapplet
  4. They become non-reusable once used in more than one mapping

Explanation

Source and target definitions are inherently reusable objects; a single definition in a folder can be referenced by any number of mappings without creating copies. Only transformations, mapplets, and certain other objects carry an explicit reusable or non-reusable setting that the developer can toggle.

Question 7Repository Objects, Source and Target Definitions

A flat file source definition loads a file whose accented characters appear garbled even though the byte content of the file is unchanged. Which property of the source definition should be reviewed first?

  1. The code page Correct answer.
  2. The column precision
  3. The delimiter setting
  4. The header options

Explanation

The code page on a flat file definition tells the Integration Service how to interpret the bytes as characters, so a mismatch between the file encoding, for example UTF-8, and the definition code page produces garbled text. Delimiter and header options affect how rows and fields are split, and precision affects numeric sizing, not character interpretation.

Question 8Repository Objects, Source and Target Definitions

A target definition was built manually because the table does not yet exist in the database. What does the Generate/Execute SQL option in Target Designer provide for that definition?

  1. A session that loads the target table
  2. A CREATE TABLE statement and related DDL for the target Correct answer.
  3. A SQL override inserted into the mapping
  4. An index rebuild script for the target table

Explanation

Generate/Execute SQL builds the data definition language needed to create the target object from the definition's columns, datatypes, precision, and keys, and can run it against the configured connection. It creates database structure; it does not create sessions or alter how the mapping reads and writes rows.

Question 9Repository Objects, Source and Target Definitions

Folder SALES holds the master definition of the CUSTOMER table, and folder MKT uses a shortcut to that definition inside one of its mappings. A developer adds a column to the master definition in SALES. What is the effect in MKT?

  1. The shortcut keeps the old structure until it is copied as a new definition
  2. MKT keeps a private snapshot taken when the shortcut was created
  3. The shortcut is invalidated and must be recreated from scratch
  4. The shortcut reflects the new column because it points to the same object Correct answer.

Explanation

A shortcut is a reference to the original object, not a copy, so the shortcut exposes the current structure of the definition in SALES, including the added column. Because the change propagates everywhere the shortcut is used, impact analysis should be run before altering a master definition that other folders depend on.

Question 10Repository Objects, Source and Target Definitions

In a repository configured with version control, what happens when a developer saves a mapping that already exists after modifying it?

  1. The stored copy is overwritten in place and the prior state is lost
  2. Version numbers restart at 1 whenever the object moves to another folder
  3. A new version with an incremented number is created and earlier versions are kept Correct answer.
  4. Only mappings are versioned, while source and target definitions are not

Explanation

In a versioned repository each save of a changed object produces a new version with an incremented version number, and the previous versions remain available for comparison or restore until they are purged. Versioning applies to objects saved in the repository, not to mappings alone.

Question 11Repository Objects, Source and Target Definitions

Which PowerCenter Designer tool is used to import a relational target definition from an Oracle table?

  1. Source Analyzer
  2. Mapping Designer
  3. Target Designer Correct answer.
  4. Workflow Manager

Explanation

Target definitions are created and maintained in the Target Designer. From there you can import a table definition using a configured relational connection, so the columns and data types match the database.

Question 12Repository Objects, Source and Target Definitions

In a flat file source definition, which property specifies the character that separates one column from the next?

  1. Delimiter Correct answer.
  2. Header
  3. Code page
  4. Escape character

Explanation

The delimiter property identifies the column separator in a delimited flat file, such as a comma or pipe. Escape character handles special characters inside data, Header controls header rows, and code page controls character encoding.

Question 13Repository Objects, Source and Target Definitions

Which type of source definition is created by importing a COBOL copybook into the Source Analyzer?

  1. COBOL source definition Correct answer.
  2. Relational source definition
  3. XML source definition
  4. Flat file source definition

Explanation

A COBOL copybook describes record layouts for COBOL data, and Source Analyzer uses it to build a COBOL source definition. The resulting definition captures fields, data types, and group structures from the copybook.

Question 14Repository Objects, Source and Target Definitions

A developer copies a source definition from one folder to another using the Copy option rather than creating a shortcut. What is the result?

  1. It cannot be edited after being copied.
  2. It is a separate definition independent of the original. Correct answer.
  3. It automatically updates when the original changes.
  4. It remains a shortcut linked to the original.

Explanation

Copy creates a new repository object with its own metadata in the destination folder. Subsequent edits to the original definition do not propagate to the copy, unlike a shortcut, which continues to reference the master object.

Question 15Repository Objects, Source and Target Definitions

In a mapping, which object references a relational source definition and can contain a SQL override for reading the source?

  1. The target definition
  2. The source definition itself
  3. The Lookup transformation
  4. The Source Qualifier transformation Correct answer.

Explanation

A Source Qualifier transformation is connected to the source definition and represents the read operation in the mapping. Its properties include the SQL override, which replaces the default generated query for relational sources.

Question 16Repository Objects, Source and Target Definitions

A developer wants to use Preview Data on a relational source definition in the Source Analyzer. What must be available for the preview to return rows?

  1. A target definition in the same folder
  2. A mapping that uses the source
  3. A valid database connection to the source Correct answer.
  4. A session that has been run at least once

Explanation

Preview Data executes a query against the source database, so the source definition must be associated with a working relational connection. Without a valid connection, PowerCenter cannot retrieve rows for the preview.

Question 17Repository Objects, Source and Target Definitions

A flat file contains a delimiter character inside a text value, and the developer wants PowerCenter to treat it as data rather than as a column separator. Which flat file source definition property should be configured?

  1. Escape character Correct answer.
  2. Code page
  3. Header
  4. Delimiter

Explanation

The escape character property defines a character that tells PowerCenter the following delimiter or quote is part of the data. This allows delimited files to carry the delimiter inside a value without splitting the column incorrectly.

Question 18Repository Objects, Source and Target Definitions

When creating a target definition for a table that already exists in the target database, which approach best ensures the definition matches the table's column names and data types?

  1. Create the columns manually from the table documentation.
  2. Use Generate/Execute SQL to recreate the table.
  3. Copy the definition from a flat file source.
  4. Import the definition from the target database. Correct answer.

Explanation

Importing the target definition reads the existing table metadata through a connection, so column names, data types, and lengths match the database. Manual creation can introduce mismatches, and Generate/Execute SQL is intended for creating a table, not for importing an existing one.

Question 19Repository Objects, Source and Target Definitions

A master source definition in folder SALES is used through shortcuts in folders MKT and FIN. A developer renames a column in the master definition. What is the immediate effect?

  1. The shortcuts keep the old column name until refreshed.
  2. The shortcuts are deleted and must be recreated.
  3. All dependent mappings update automatically without validation.
  4. The shortcuts reflect the change, and dependent mappings may become invalid. Correct answer.

Explanation

A shortcut points to the master repository object, so metadata changes such as a column rename are visible through the shortcut. Mappings that reference the affected column may no longer match and typically require validation or reconciliation before they run correctly.

Question 20Repository Objects, Source and Target Definitions

A developer must create a source definition for a relational table, but no database connection is available in the repository. Which approach is valid, and what is the main risk?

  1. Import a target definition; the risk is reversed column order.
  2. Use Generate/Execute SQL; the risk is dropping the table.
  3. Create a flat file definition instead; the risk is losing row data.
  4. Create the definition manually; the risk is metadata mismatch with the table. Correct answer.

Explanation

Source Analyzer can create a source definition manually by entering the table and column metadata. The main risk is that the manual metadata may not match the actual database table, causing mapping or session failures at run time.

Question 21Repository Objects, Source and Target Definitions

In the Source Analyzer, which operation compares a relational source definition with its database table and reports added, removed, or changed columns?

  1. Reconcile Correct answer.
  2. Preview Data
  3. Generate/Execute DDL
  4. Validate

Explanation

Reconcile reads the current database metadata and compares it with the stored relational source definition, highlighting differences such as new columns, dropped columns, or changed data types. Preview Data only returns sample rows, Generate/Execute DDL applies to target table creation, and Validate checks object or mapping validity.

Question 22Repository Objects, Source and Target Definitions

In a relational source definition, which property identifies the database schema that owns the table?

  1. Business Name
  2. Owner Name Correct answer.
  3. Database Type
  4. Source Table Name

Explanation

The Owner Name property specifies the schema or owner qualifier for a relational source table. Source Table Name identifies the physical table, Database Type identifies the DBMS, and Business Name is a descriptive label used for documentation.

Question 23Repository Objects, Source and Target Definitions

For a fixed-width flat file source definition, which metadata tells PowerCenter the byte range occupied by each column?

  1. The field delimiter character
  2. The row delimiter character
  3. The text quote character
  4. The start position and length of each column Correct answer.

Explanation

Fixed-width flat files have no column delimiters, so each column must be defined by its starting position and length in the record. Delimiters and quote characters apply to delimited files, and the row delimiter marks the end of a record rather than a column boundary.

Question 24Repository Objects, Source and Target Definitions

Which PowerCenter source definition type is created by importing an XML schema (XSD) in the Source Analyzer?

  1. Relational definition
  2. XML definition Correct answer.
  3. COBOL definition
  4. Flat file definition

Explanation

Importing an XML schema creates an XML source definition that represents the element and attribute hierarchy described by the XSD. Relational definitions come from database tables, COBOL definitions from copybooks, and flat file definitions from file layouts.

Question 25Repository Objects, Source and Target Definitions

A flat file source contains two header lines that are not data. Which source definition property should be set so PowerCenter skips them?

  1. Escape Character
  2. Row Delimiter
  3. Number of Header Lines in the Header Options Correct answer.
  4. Column Delimiter

Explanation

The Header Options property records how many leading lines in the flat file are headers, so the Integration Service starts reading data after those lines. Row Delimiter, Escape Character, and Column Delimiter control record and field parsing but do not skip leading header records.

Question 26Repository Objects, Source and Target Definitions

What is the effect of marking a column as a primary key in a relational source definition?

  1. It records key metadata without enforcing uniqueness on source rows. Correct answer.
  2. It causes the Integration Service to reject duplicate source rows.
  3. It creates a unique constraint on the source table.
  4. It adds a primary key constraint to the target table.

Explanation

Primary key information in a source definition is metadata that documents the key structure for the definition; PowerCenter does not enforce it against rows read from the source. PowerCenter also does not create or alter constraints in the source database or automatically add a target primary key.

Question 27Repository Objects, Source and Target Definitions

Which target definition property identifies the database type so the Designer can assign native data types and Generate/Execute DDL can produce correct syntax?

  1. Owner Name
  2. Target Load Type
  3. Database Type Correct answer.
  4. Business Name

Explanation

The Database Type property tells PowerCenter which DBMS the target represents, which affects native data type choices and DDL syntax. Target Load Type controls load behavior, Owner Name identifies the schema, and Business Name is descriptive metadata.

Question 28Repository Objects, Source and Target Definitions

A relational source definition is named CUSTOMER_DIM in the repository, but the physical Oracle table is named CUSTOMER. Which source definition property must be changed?

  1. Owner Name
  2. Source Table Name Correct answer.
  3. Database Type
  4. Description

Explanation

The Source Table Name property specifies the physical table that the source definition reads; the definition name itself need not match the database table name. Owner Name controls the schema, Database Type controls the DBMS, and Description is documentation only.

Question 29Repository Objects, Source and Target Definitions

In a repository configured with version control, a developer needs to modify a target definition that is currently checked in. What must the developer do first?

  1. Edit it directly without checking out.
  2. Create a shortcut to the target definition.
  3. Export it to an XML file.
  4. Check out the target definition. Correct answer.

Explanation

Version control requires a checked-in object to be checked out before it can be modified, which creates an editable working copy for the developer. Editing directly, creating a shortcut, or exporting the object does not produce a modifiable checked-out version.

Question 30Repository Objects, Source and Target Definitions

Which statement correctly describes how a relational source definition relates to the database connection used at run time?

  1. It stores the connection in the target definition instead.
  2. It stores the run-time connection and credentials used by the session.
  3. It stores a connection object for Preview Data but not for sessions.
  4. It stores table metadata, while the session supplies the connection object. Correct answer.

Explanation

A relational source definition stores metadata such as the table name, owner, columns, and database type, but the run-time database connection is supplied by the session through a connection object. Credentials and connection details are not embedded in the source definition itself.

Question 31Repository Objects, Source and Target Definitions

In PowerCenter Designer, which tool is used to create and maintain target definitions that describe the tables or files receiving data?

  1. Mapping Designer
  2. Target Designer Correct answer.
  3. Workflow Manager
  4. Source Analyzer

Explanation

Target Designer is the Designer tool for creating and editing target definitions. Source Analyzer handles source definitions, Mapping Designer builds mappings, and Workflow Manager builds workflows and sessions.

Question 32Repository Objects, Source and Target Definitions

A flat file source definition must be configured to read either delimited columns or fixed-width columns. Which property controls this choice?

  1. Text Qualifier
  2. Format Correct answer.
  3. Code Page
  4. Column Delimiter

Explanation

The Format property selects Delimited or Fixed Width for a flat file source definition. Column Delimiter and Text Qualifier apply after the file is treated as delimited, while Code Page controls character encoding.

Question 33Repository Objects, Source and Target Definitions

A developer has created a relational target definition in the Target Designer and now wants the database to create the corresponding physical table. Which target definition command performs this action?

  1. Generate/Execute SQL Correct answer.
  2. Synchronize source definition with the database
  3. Validate the target definition against the database
  4. Preview target data using a database connection

Explanation

Generate/Execute SQL builds DDL from the target definition and can run it against the configured database connection. Validate checks the definition, Preview Data displays rows, and Synchronize is used for source definitions.

Question 34Repository Objects, Source and Target Definitions

A table used as a relational source has a new column added in the database. The existing source definition does not show it. Which Source Analyzer operation should the developer use to update the definition with the database structure?

  1. Generate SQL for the target
  2. Synchronize Correct answer.
  3. Validate the mapping
  4. Compare source definition with database

Explanation

Synchronize merges the database table structure into the existing source definition, adding new columns and updating changed ones. Compare only reports differences, Validate checks mapping validity, and Generate SQL is a target-side DDL action.

Question 35Repository Objects, Source and Target Definitions

A flat file source contains characters in a non-default encoding, and the developer must specify the character set used to interpret the file. Which flat file source definition property should be set?

  1. Database Type
  2. Key Type
  3. Row Delimiter
  4. Code Page Correct answer.

Explanation

Code Page tells the Integration Service which character encoding to use when reading the flat file. Database Type is a relational property, Row Delimiter marks record ends, and Key Type is column metadata.

Question 36Repository Objects, Source and Target Definitions

A flat file uses a backslash to make a text qualifier inside a value be treated as literal data. Which flat file source definition property should be configured?

  1. Text Qualifier
  2. Column Delimiter
  3. Escape Character Correct answer.
  4. Row Delimiter

Explanation

Escape Character identifies the character that makes the following character literal, so a qualifier inside a value can be read as data. Text Qualifier marks the enclosing quote, while Column and Row Delimiter separate fields and records.

Question 37Repository Objects, Source and Target Definitions

A relational source is imported from Oracle, and one column is defined as NUMBER(10,2). Which PowerCenter data type is assigned to that source definition column by default?

  1. Double
  2. BigInt
  3. Decimal Correct answer.
  4. Integer

Explanation

Oracle NUMBER with precision and scale is imported as a PowerCenter Decimal column, preserving the 10 digits and 2 decimal places. Integer and BigInt hold whole numbers, and Double is a floating-point type.

Question 38Repository Objects, Source and Target Definitions

A flat file source uses a special character sequence to mark the end of each record instead of a standard newline. Which source definition property defines this sequence?

  1. Row Delimiter Correct answer.
  2. Text Qualifier
  3. Escape Character
  4. Column Delimiter

Explanation

Row Delimiter defines the character or sequence that terminates each record in the flat file. Column Delimiter separates fields, Text Qualifier encloses values, and Escape Character protects qualifier characters.

Question 39Repository Objects, Source and Target Definitions

A developer marks the ORDER_ID column as a primary key in a relational target definition and then runs Generate/Execute SQL. What does this key setting affect?

  1. It creates a partitioned target load automatically when the session starts.
  2. It adds a primary key constraint to the generated CREATE TABLE statement. Correct answer.
  3. It makes the Integration Service reject duplicate ORDER_ID values during every session.
  4. It forces the session to use Update Strategy instead of Insert for all rows.

Explanation

Generate/Execute SQL uses the Key Type metadata in the target definition to include a primary key constraint in the CREATE TABLE DDL. The Integration Service does not enforce target key types at run time, and update behavior is controlled by Update Strategy, not by this setting.

Question 40Repository Objects, Source and Target Definitions

A developer plans to drop a column from a source table and needs to find every mapping, session, and workflow that references that column. Which Repository Manager analysis feature should be used?

  1. Lineage Analysis
  2. Impact Analysis Correct answer.
  3. Synchronize
  4. Compare

Explanation

Impact Analysis in the Repository Manager shows repository objects that depend on the selected object or column, which is what a developer needs before dropping it. Lineage Analysis traces data movement, while Compare and Synchronize are Source Analyzer operations.

Question 41Mapping Design and Core Transformations

In a PowerCenter mapping, which transformation is designed to calculate a new value for every row using expression ports and can also hold variable ports that retain values across rows?

  1. Aggregator transformation
  2. Sorter transformation
  3. Router transformation
  4. Expression transformation Correct answer.

Explanation

The Expression transformation evaluates expressions row by row and writes calculated results to output ports. It can also use variable ports to hold intermediate values that can be referenced by later ports in the same transformation. This makes it the standard choice for row-level calculations in a mapping.

Question 42Mapping Design and Core Transformations

Which Router transformation behavior routes a row when it matches none of the user-defined groups?

  1. The row is passed to the next transformation without change.
  2. The row is rejected and written to the session reject file.
  3. The row is duplicated to every group.
  4. The row is written to the default group. Correct answer.

Explanation

A Router transformation contains user-defined groups plus a default group. When a row satisfies no user-defined group condition, PowerCenter sends it to the default group. If the default group is connected, that row continues down the default pipeline.

Question 43Mapping Design and Core Transformations

Which Sequence Generator port supplies the next generated value to downstream transformations during the mapping run?

  1. STARTVAL
  2. CURRVAL
  3. NEXTVAL only after the session commits
  4. NEXTVAL Correct answer.

Explanation

The NEXTVAL port generates the next sequence value for each row and is the port normally connected to downstream transformations. CURRVAL holds the current generated value, while STARTVAL is a configuration property rather than a runtime output port.

Question 44Mapping Design and Core Transformations

An Aggregator transformation must calculate total salary per department and also output the department name. Which design is valid?

  1. Use department as a group-by port and SUM(salary) as an aggregate expression port. Correct answer.
  2. Use only salary as the group-by port and department name as an aggregate expression.
  3. Remove department name from the mapping because the Aggregator cannot output group-by ports.
  4. Use department name as an aggregate expression and salary as a group-by port.

Explanation

Group-by ports define the groups over which aggregate expressions are calculated. To calculate salary totals per department, department must be a group-by port and salary must be used inside an aggregate expression such as SUM(salary). The department port can also be passed to downstream transformations.

Question 45Mapping Design and Core Transformations

Which Lookup transformation property determines what PowerCenter does when more than one lookup row satisfies the lookup condition?

  1. Source filter
  2. Join type
  3. Lookup policy on multiple match Correct answer.
  4. Lookup cache type

Explanation

The Lookup policy on multiple match property controls the behavior when multiple lookup rows match, such as reporting an error or using the first, last, or any matching value. It is separate from caching settings and from the lookup source filter. This property is important when the lookup condition is not guaranteed to be unique.

Question 46Mapping Design and Core Transformations

Two relational sources with different keys must be joined in a PowerCenter mapping. Which Joiner transformation configuration is required?

  1. Use one master source, one detail source, and define a join condition. Correct answer.
  2. Both sources must be sorted by the join key and must expose identical port names.
  3. The Joiner must be connected directly to a Router transformation.
  4. Both sources must use the same source qualifier filter.

Explanation

A Joiner transformation joins two sources by designating one as the master and the other as the detail, then defining the join condition between their ports. Sorted input can improve performance but is not a requirement, and the sources do not need identical port names. The join condition expresses how the different keys relate.

Question 47Mapping Design and Core Transformations

Which Update Strategy expression marks an incoming row for update in the target when the row already exists and should be changed?

  1. DD_DELETE
  2. DD_INSERT
  3. DD_UPDATE Correct answer.
  4. DD_REJECT

Explanation

The Update Strategy transformation uses row-level constants to tell the session how to treat each row. DD_UPDATE marks a row for update in the target, while DD_INSERT, DD_DELETE, and DD_REJECT request insertion, deletion, and rejection respectively. The session must also be configured to perform the corresponding target operation.

Question 48Mapping Design and Core Transformations

Which Source Qualifier capability lets you change the SQL that PowerCenter sends to a relational source?

  1. Update Strategy expression
  2. Target load plan
  3. Lookup override
  4. SQL override Correct answer.

Explanation

The SQL override property in a Source Qualifier replaces the default query that PowerCenter generates for a relational source. It is commonly used to add joins, filters, or database-specific SQL when the default query is insufficient. The override must return ports that are compatible with the Source Qualifier output.

Question 49Mapping Design and Core Transformations

Which statement about a Union transformation that combines multiple input groups is correct?

  1. It automatically removes duplicate rows across all connected input groups.
  2. It requires one master input group and one detail input group for the merge.
  3. It routes each input group to a separate output group based on conditions.
  4. It merges all input groups into one pipeline and keeps duplicate rows. Correct answer.

Explanation

A Union transformation merges rows from multiple connected input groups into a single output pipeline. It does not require a master-detail relationship and does not remove duplicate rows by default. If deduplication is needed, a separate transformation such as an Aggregator or Sorter with distinct processing must be added.

Question 50Mapping Design and Core Transformations

Which transformation is appropriate when a single input row containing repeating groups must produce multiple output rows, such as converting a COBOL record with an OCCURS clause?

  1. Aggregator transformation
  2. Transaction Control transformation
  3. Normalizer transformation Correct answer.
  4. Rank transformation

Explanation

The Normalizer transformation converts one input row into multiple output rows, which makes it suitable for repeating groups such as COBOL OCCURS clauses and certain VSAM structures. It generates occurrence identifiers so downstream logic can distinguish the expanded rows. Aggregator, Rank, and Transaction Control serve different purposes in a mapping.