What is a control task?
What is a pipeline partition and how does
provide a session with higher performance?
What is the maximum number of partitions that
can be defined for in a single pipeline?
Pipeline partitions is designed to increase
performance, however list one of it’s disadvantages?
What is a dynamic session partition?
List three dynamic partitioning configurations
that cause a session to run with one partition
What is pushdown optimization?
List the different types of pushdown optimization
that can be configured?
What databases are we able to configure pushdown
List several transformations that work with
pushdown optimization to push logic to the database?
What is real-time processing?
What types of real-time data can be processed
with Informatica PowerCenter?
What is a real-time processing terminating
List three real-time processing terminating
What is real-time processing message recovery?
What factors play a part in determining a commit
List all configurable commit types?
What performance concerns should you be aware of
when logging error rows?
What functionality is provided by the
Integration Service when error logging is enabled?
What is the difference between stopping and
aborting a workflow session task?
What is a concurrent workflow?
What is Informatica PowerCenter grid processing
and its benefits?
List the types of parameters and variables that
can be defined within a parameter file?
With PowerCenter, what two locations can one
specify a parameter file?
How are mapplet parameters and variables defined
withing a parameter file different?
What is an SQL Transformation in Informatica?
What is dynamic lookup cache?
What is a Unstructured Data transformation?