Tag: technology

Resilience

Failover

Recovery

Transition

Service Manager

Administration Console

A node

A grid

Script mode

Bulk mode

Query mode

Normal mode

Both XML Generator transformation and XML Parser transformation are active and connected transformations

The XML Parser transformation reads XML data from a single input port and writes data to one or more output ports

The XML Generator transformation accepts data from multiple ports and writes XML through a single output port

XML Generator transformation ia an active transformation and XML Parser transformation is a passive transformation

Repository service is responsible for storing and retrieving the metadata from repository database

Integration service is responsible for running and scheduling of jobs

If repository service is down, we can’t create mapping

If repository service is down, we can create mapping

Generated key port is generated for each REDEFINES clause

Generated key port is generated for each OCCURS clause

Generated Column ID is generated for each OCCURS clause

Generated Column ID is generated for each REDEFINED clause

The input/output parameters in the expression must match the input/output ports in the Stored Procedure transformation

A single output parameter is returned using the variable PROC_RESULT

The same instance of a Stored Procedure transformation cannot run in both connected and unconnected mode in a mapping

We cannot have multiple levels of nested stored procedures

Relational tables, views, and synonyms

Fixed-width and delimited flat files that contain binary data

COBOL files

XML files and Data models

With a normal join, the Integration Service discards all rows of data from the master and detail source that do not match, based on the condition.

A master outer join keeps all rows of data from the master source and the matching rows from the detail source. It discards the unmatched rows from the detail source

A detail outer join keeps all rows of data from the detail source and the matching rows from the master source. It discards the unmatched rows from the master source

A full outer join discards all rows of data from both the master and detail sources.

Stored Procedure Transformation

XML Transformation

HTTP Transformation

Transaction Control Transformation