Designer
What defines transformation process and logics?
PowerCenter Designer
What defines the run-time properties, known as sessions?
Workflow Manager
Transformation uses multiple transformation conditions
Router Transformation
What assigns permission to users and manages folders?
Repository manager
Set of rules and instructions that are to be applied to define data flow and data load at the destinations
Transformation
3 major components of the Workflow Manager
Task Designer, Task Developer, Workflow Designer
Transformation used for data manipulation and output generation using conditional statements
Expression Transformation
4 Informatica client tools
Repository manager, Workflow monitor, Workflow Manager, PowerCenter Designer
A set of transformations that you can use in multiple mappings?
Mapplet
A set of individual tasks
Batch
Transformation used to sort large volumes of data through multiple ports
Sorter Transformation
Set of instructions that are to be applied while transferring data from source to target
Session task
2 ways to update the source definition
You can edit the existing source definition or import a new source from the database.
What command completely stops the integration service from reading, processing and writing data to the target?
ABORT
Its basic use is to generate integer value with NEXTVAL and CURRVAL
Sequence Generator Transformation
What command stops reading the data in the data source but continues processing and writing it to the target?
STOP