CSI Data Mapping & Transformation 2

Question 1

Which transformation pattern converts a single source record into multiple target records?

Accepted Answer

One-to-many splitting

Answer

One-to-many splitting (or explosion) breaks a single source record into multiple target records, such as expanding a line-item order into individual product records.

Question 2

In XSLT-based data transformation, what is the primary role of a stylesheet?

Accepted Answer

Defining rules for transforming XML documents into another format

Answer

An XSLT stylesheet defines templates and transformation rules that convert XML source documents into a target format such as HTML, another XML structure, or plain text.

Question 3

When performing a many-to-one aggregation in data mapping, which operation is most commonly applied?

Accepted Answer

Combining multiple source records into a single target record using a function like SUM or COUNT

Answer

Many-to-one aggregation consolidates multiple source records into a single target record, typically using aggregate functions such as SUM, AVG, MAX, or COUNT.

Question 4

A canonical data model in enterprise integration is best described as:

Accepted Answer

A common, application-neutral data format used as an intermediary for message translation

Answer

A canonical data model (CDM) is a vendor-neutral, agreed-upon intermediate format that decouples source and target systems, reducing the number of point-to-point transformations needed.

Question 5

Which data quality issue occurs when a field expected to hold a date contains a string like 'N/A'?

Accepted Answer

Data type mismatch

Answer

A data type mismatch occurs when a value stored in a field does not conform to the expected data type, such as text appearing in a date column.

(CSI) Certified System Integrator Practice Test

(CSI) Certified System Integrator Practice Test

CSI Data Mapping & Transformation 2