Informatica PowerCenter and Business Objects Quiz

Informatica PowerCenter Server uses native database drivers for optimal connectivity and performance. For Oracle databases, it uses Oracle Call Interface (OCI) client libraries rather than generic ODBC or JDBC drivers.

The Repository Server communicates with Repository Agents to execute repository operations. When a client requests an operation, the Repository Server sends notifications or commands to the appropriate Repository Agent, which then performs the actual work on the repository.

Mapplets in Informatica are reusable sets of transformations that can be used across multiple mappings. They represent a collection of transformations and can be reused. When a mapping containing a mapplet executes, the Informatica Server expands the mapplet inline at runtime.

SQL override in Source Qualifier transformation allows you to write custom SQL queries to filter data during extraction from the source. While it can also join tables from the same homogeneous source, joining heterogeneous sources (different database types) is typically done through joiner transformations, not SQL override alone.

For flat file sources in a mapping, the Source Qualifier transformation must immediately follow the source definition. The Source Qualifier represents the rows that the Integration Service reads from the flat file and is required for all source types including flat files.

Informatica PowerCenter defines its own set of data types (such as string, integer, decimal, date/time, binary, etc.) which are used internally within transformations. These Informatica data types map to corresponding data types in source and target databases.

Source and target definitions in Informatica can be created through multiple methods: by importing from database tables or files, by manually creating them from scratch, or by using a combination of both import and manual definition methods.

PMCMD is Informatica's command-line utility specifically designed for workflow execution and management. You can run workflows from command line or scripts using pmcmd startworkflow. The repository server admin console is used for monitoring and administration, not for executing workflows.

Informatica PowerCenter allows executing multiple sessions in parallel within a workflow. You can configure concurrent execution settings to improve ETL performance. The Integration Server can run multiple sessions simultaneously as long as system resources permit.

Universe is the semantic layer in BusinessObjects that maps database objects to business terminology. It acts as an abstraction layer between the physical database and end-user reporting tools like WebI and DeskI. The universe contains classes, objects, and measures that users see in their reporting interface.

Web Intelligence allows using logical operators (AND, OR, NOT) when building conditions in query filters. You can combine multiple conditions using these logical operators to create complex filter expressions. This is a standard feature available in the Query Panel.

Web Intelligence reports can be saved in various formats including Excel (.xls), PDF (.pdf), CSV, and HTML. The XML format is not a standard export option for WebI reports. The Save As dialog typically shows the supported formats, and .xml is not among the default options.

WebI provides drill up (navigate to higher hierarchy level) and drill down (navigate to more detailed level) as standard analysis features. Drill by allows drilling on a specific dimension or hierarchy. While drill through exists, it's not typically listed as a standard drill option in the same category.

Drill down analysis in WebI is performed on dimension objects that contain hierarchical data. Dimensions allow users to navigate from summary data to more detailed levels. Measures contain numeric values and details provide additional descriptive information, but dimensions are the objects used for hierarchical drill operations.

Join path problems (loops or ambiguity) in BusinessObjects universes can be resolved using aliases and contexts. Aliases create alternate references to the same table to break loops, while contexts define separate join paths for different query scenarios. Using both techniques together provides comprehensive solutions for complex join path issues.

Universe Designer allows linking two universes by creating a derived universe that inherits components from a base universe. This feature enables reusability and modular design where one universe can include components from another. The link is established through the universe's include or inheritance mechanism.

The Informatica Designer tool provides debugging capabilities for mapping validation and transformation logic testing.

Reusable transformations must be developed in the Transformation Developer, not the Mapping Designer. Mapping Designer is for creating mappings using existing transformations.

Informatica Lookup transformations are primarily categorized as connected or unconnected depending on their integration in the mapping pipeline. They are also typically passive because they return a single row for each lookup query, whereas active lookups returning multiple rows are a distinct, less common configuration.