Informatica PowerCenter Technical Quiz

View root defines the top-level element as parent to all view elements. Two different views can reference the same view row from an XML source. A view row can be a type, element, or attribute - not must be only one of these.

PowerCenter supports String, Date, and Float types for XML processing. Number and Binary XML data types are not directly supported - Number requires decimal mapping, Binary needs encoding handling.

Custom transformations in PowerCenter are written in C, C++, or Java. These languages provide the performance and integration needed for custom code within the Informatica ecosystem. Perl and C# are not supported for Custom transformations.

Informatica PowerCenter provides multiple application services. Repository Service manages metadata. Integration Service executes workflows. SAP BW Service connects to SAP. Web Services Hub exposes SOA capabilities.

High availability systems require multiple components to ensure continuous operation. Resilience allows the system to recover from failures, failover provides automatic switching to backup systems, and recovery procedures restore normal operations after an outage. All three (Resilience, Failover, Recovery) are fundamental components of a high-availability architecture.

Service process states represent the lifecycle of a running service. Common states include Running (actively executing), Starting (initializing), Started (ready state), and Stopped (terminated). Aborted is not a standard service process state - it describes an outcome or termination condition rather than a state in the service lifecycle.

The DTM (Data Transformation Manager) in Informatica PowerCenter performs multiple critical tasks: it retrieves and validates session configuration from the repository (A), verifies that the integration service has proper permissions on connection objects (B), coordinates worker DTM processes across grid nodes for parallel execution (C), and dynamically adds partitions when dynamic partitioning is enabled (D). All four tasks are core DTM responsibilities.

The 'Use Workflow Manager' privilege in Informatica grants specific workflow operations. Users with this privilege can abort workflows, restart workflows, recover suspended workflows, and stop workflows. 'Resume workflow' is NOT part of the standard 'Use Workflow Manager' privilege set - resume is typically controlled by separate permissions or is implicit in recover/restart operations.

The Copy Wizard in Informatica analyzes connection objects during copy operations and displays different status messages: 'No Match Found' when the source connection doesn't exist, 'Match Found' when identical connections exist, 'Match Found - Permission Denied' when the connection exists but cannot be accessed (and it will copy with a new name), and 'Permissions Denied' when access is blocked. All four information types are displayed by the Copy Wizard.

Informatica's Unstructured Data transformation can read multiple industry-standard data formats. SWIFT is used for financial messaging, HL7 for healthcare data exchange, Windows Word format for document processing, and EDI-X12 for electronic data interchange in business transactions. All four formats are supported by the Unstructured Data option.

When 'collect performance data' is enabled at the session level, Informatica tracks detailed session-specific performance metrics. This includes buffer block sizes used during data flow, cache sizes configured for Aggregator, Rank, Lookup, and Joiner transformations, and detailed statistics for Lookup transformations. All listed metrics (A, B, C) are part of performance data collection.

Email tasks in Informatica workflows use built-in variables to embed session information. The %b variable specifically displays the session start time in the email notification. Other variables like %s, %t, %n, and %r represent different session or task properties, but %b is the correct variable for session start time.

Error logs in Informatica can be written to different storage types. Relational error logs store error information in database tables for structured querying and analysis. File-based error logs write errors to flat files (text, CSV) for portability and external processing. XML (C) and Binary (D) are not standard error log types - error logs are typically written in readable formats for debugging.

For Source Qualifier transformations with relational sources, specific partition types are supported. Key range partitioning divides data based on key value ranges. Pass-through partitioning sends rows to partitions without modification. Database partitioning leverages the source database's native partitioning. Round Robin and Hash Auto Keys are NOT valid for relational Source Qualifiers - they're used for other transformation types.

Pushdown optimization in Informatica improves performance by pushing transformation logic to the database. Source-side pushdown executes logic near the source database. Target-side pushdown executes near the target. Full pushdown pushes the entire transformation logic to the database. All three modes are valid configuration options for pushdown optimization.

The Control task provides various control flow options but does not include 'Fail me', 'Fail parent', 'Stop parent', or 'Abort Parent' as standard control options. These are not valid Control task controls, making 'None of the Above' the correct choice.

Events are categorized into pre-defined events (built into the system) and user-defined events (created by developers). 'Event raise' and 'File watch' are not event types but operations or mechanisms, not categories.

The default port for the Web services hub is 7333. This is a standard configuration setting for web services in certain systems.

In lookup override queries, the double dash (--) is used to override the default sorting behavior of the lookup operation. It allows custom sort orders to be specified.