Data Management & Reporting Tools

BO Main.Key likely contains repository information and security domain addresses as core metadata. 'All of the above' is incorrect since option C (meta data) is too vague - it's already covered in A and B.

Crystal Reports provides summary features including sum, count, average, and other aggregate functions. These can be added to groups or the entire report using the Insert Summary functionality. The question has grammatical issues but the core assertion about Crystal Reports' capability is correct.

In Informatica and similar ETL tools, a report can be created using data from multiple databases. This is a fundamental capability of reporting tools that allows combining data from different sources into a single output.

Sequence Generator and Update Strategy transformations cannot immediately precede Joiner transformations. The Joiner transformation expects specific input data structures that these transformations don't provide - Sequence Generator generates sequences while Update Strategy handles database operations.

Update Strategy transformation supports DD_INSERT, DD_UPDATE, and DD_DELETE operations for handling database changes. DD_TRUNCATE is not a valid operation type in this transformation - it's typically a database-level operation performed separately.

In Expression transformation, a port can serve as both an output port and a variable port. Output ports pass data to subsequent transformations while variable ports store intermediate calculations or values within the transformation.

Source Qualifier transformation converts native datatypes from various sources to Informatica's standard datatypes. This allows the ETL tool to handle data consistently regardless of the source system's native format.

The default caching mechanism for lookup transformation is dynamic caching. This means the cache is built as needed during transformation execution rather than being static or persistent across multiple runs.

External Tables transformation allows you to define database table structures over flat files. This enables treating flat files as if they were database tables, providing a consistent interface for data access.

Expression transformation processes data on a row-by-row basis. It evaluates expressions for each individual row and can perform calculations, derivations, and conditional logic on each row independently.

OWB (Oracle Warehouse Builder) supports both Type-1 and Type-2 mappings. Type-2 refers to Slowly Changing Dimension Type 2, which is a specific pattern of Type-2 SCD that OWB can handle.

For Type-2 mappings, the target table property is set to INSERT/UPDATE. This allows the mapping to handle both inserting new records and updating existing records when tracking historical changes.