Informatica PowerCenter and BI Tools Fundamentals

Application Source Qualifier in Informatica PowerCenter is specifically designed to work with Salesforce.com sources, allowing data extraction from Salesforce. COBOL sources use COBOL source definitions, XML sources use XML Source Qualifiers, and relational sources use standard Source Qualifiers.

SQL Server Analysis Services (SSAS) is the Microsoft BI service specifically designed for creating and managing OLAP cubes and multidimensional databases. SSIS handles ETL, SSRS handles reporting, and SQL RDBMS is the relational database engine - none of these create OLAP databases.

STARTED is a workflow-specific reserved variable in Informatica PowerCenter that returns the datetime when a workflow began execution. WORKFLOWSTARTTIME, PROC_RESULT, and SYSDATE are not reserved words for workflow expressions - they belong to different contexts.

In PowerCenter 8.x, the infasetup command is used to define and configure nodes and domains. infacmd is for command-line administration, pmcmd is for workflow commands, and pmrep is for repository management.

In Informatica PowerCenter, Gateway Service and Log Service are classified as Core Services that run on every node in the domain to manage basic node operations and logging.

A PowerCenter Domain consists of zero or more Grids. A Grid is a collection of nodes that can run services, and a domain must have at least one node but can have zero grids initially or multiple grids as needed.

$$$SessStartTime returns the session start time as a string value, while SESSSTARTTIME returns it as a date/time datatype. This distinction matters for type-sensitive operations and formatting.

Aggregator transformation variable ports can only contain non-aggregate and conditional expressions. Aggregate expressions cannot be used in variable ports - they must be used in output ports only. Variable ports cannot mix aggregate with non-aggregate expressions.

You cannot manually type a number value in KB, MB, or GB for Aggregator cache size. Valid methods include using the cache calculator, choosing 'Auto', or entering default sizes in mapping properties. Direct numerical input is not supported.

In PowerCenter 8.x, one Repository Service manages exactly one repository. In PowerCenter 7.x, one Repository Server could manage multiple repositories. This architectural change from 7.x to 8.x is documented and correct.

Application Source Qualifier is specifically used with Salesforce.com sources in Informatica PowerCenter. For COBOL sources you use COBOL source definitions, for XML sources you use XML Source Qualifier, and for relational sources you use standard Source Qualifier.

STARTED is a built-in variable reserved exclusively for Informatica Workflow Expressions to check the status of tasks or workflows. Other variables like SYSDATE can be used across mapping expressions as well.

In PowerCenter 8.x, the infasetup command is used to define and configure nodes and domains. infacmd is for command-line administration, pmcmd is for workflow commands, and pmrep is for repository management.

Gateway Service and Log Service are core services that can be configured by administrators. Domain Service, Licensing Service, Authentication Service, Admin Service, Integration Service, and Repository Service are either not user-configurable or are system-managed core services.

A PowerCenter Domain can consist of zero or more grids - grids are the computing resources that execute workflows, and a domain can exist without any grids or contain multiple grids. Options B, C, and D are incorrect because domains are not restricted to having exactly one grid, can have zero grids, and are not required to have at least one grid.