Informatica and Cognos Report Studio Fundamentals

The Insertable Objects pane provides access to Source (data sources), Data Item (query items), and Toolbox (lists, crosstabs, charts) for report design.

Drill-through reports enable users to click on a data point in one report and navigate to a related report with more detailed or contextual information about that specific value.

Slicer is a dimensional filter that controls which context is included in measure calculations, reducing the scope of data without affecting the display.

The Explorer Bar provides Page Explorer (page structure), Query Explorer (query design), and Condition Explorer (conditional logic) for comprehensive report development.

Report Studio supports multiple export formats including Excel for spreadsheet analysis, PDF for printing, XML for data exchange, and HTML for web viewing.

A standard Report Studio page consists of three main components: the Page Header for title/summary information, the Page Body for primary content, and the Page Footer for page numbers or summary data.

Report Studio supports List (tabular), Map (geographic), and Repeater (custom repeating layouts) report types. View is a database concept, not a Report Studio report type.

The Text Box Prompt allows users to enter a specific value they already know, such as a name or account number, for precise data filtering.

Drill Back is a specific navigation feature in Report Studio that allows returning to a previous report or state in the navigation path.

Informatica PowerCenter supports heterogeneous sources and targets, meaning it can extract data from various source systems (databases, files, applications) and load into different target systems regardless of their formats or platforms. This heterogeneity support is a key feature enabling data integration across diverse enterprise systems.

The Informatica Repository stores ALL metadata including transformation rules, mappings, workflows, source definitions, target definitions, and sessions. However, given the question structure requiring a single choice, 'Metadata for transformation' is the most comprehensive and central answer. Source and target schemas are stored but are subsets of the broader metadata. The repository is essentially a metadata database managing all ETL artifacts.

In Informatica PowerCenter architecture, the Repository Server sends notifications to the Repository Agent to perform operations on the repository. The Repository Agent acts as the interface between client applications and the repository, handling requests like saving, retrieving, and versioning metadata. This notification-based communication ensures coordinated repository operations.

In Informatica PowerCenter, folders can be copied both within the same repository and from one repository to another. Within a repository, you can create copies of folders for versioning or organizational purposes. Across repositories, you can copy folders for migration between development, testing, and production environments. The 'All the above' option correctly captures both scenarios.

A Mapplet in Informatica can be either Active or Passive depending on its transformations. An Active Mapplet contains at least one Active transformation (like Aggregator, Filter, Joiner) that changes the number of rows passing through it. A Passive Mapplet contains only Passive transformations (like Expression) that maintain the same row count. The classification depends entirely on the transformations used within the mapplet.

The Workflow Monitor in Informatica is a comprehensive tool for managing workflows. It allows you to monitor workflow execution in real-time (see progression), restart workflows from specific points, and resume workflows after failures. It provides detailed status, logs, and execution statistics, making it the central console for workflow operations and troubleshooting.

The Informatica Repository Server is responsible for managing object locking in the repository. When multiple users or processes attempt to modify repository objects concurrently, the Repository Server enforces locking to prevent conflicts and maintain data integrity.

Informatica PowerCenter allows creating header and footer rows in target flat files. This can be configured through session properties and the target flat file definition, enabling you to output header rows at the beginning and footer rows at the end of the file.

Informatica sessions offer flexible scheduling options. They can be configured to run at regular intervals (recurring schedule), on demand (manual execution), or scheduled for a one-time execution at a specific date and time.

To connect to an Informatica Repository Server, client applications need to specify the host name (or IP address) where the server is running and the port number on which it listens. The repository server name alone is not sufficient for making a connection.