OMEGA PSI PHI EXAM SCRIPT PACKAGE
2026 COMPLETE QUESTIONS WITH
VERIFIED SOLUTIONS
⩥ Mapplet. Answer: Reusable predefined process containing
transformations
⩥ Transformation. Answer: Objects used to transform data
⩥ Ports. Answer: Input or output fields
⩥ Strategy. Answer: Operation that is applied to data in a transformation
⩥ Profiling. Answer: Analysis of the content and structure of data
⩥ Transformation Pallet. Answer: All transformations displayed in scroll
bar on the left hand side
⩥ Mainline Editor. Answer: Where mappings, profiles, workflows are
created. Where transformations are placed
,⩥ Outline. Answer: Shows dependencies of an object, this can be a
transformation or rule
⩥ Object Explorer. Answer: Shows model repository, projects, folders
and data objects
⩥ Properties. Answer: Shows configurations for transformations or
mapplets / mappings
⩥ Data Viewer. Answer: Runs data through mapping and displays it.
⩥ Cheat Sheets. Answer: Provides step by step guide for a process or
transformation configuration guide
⩥ Model Repository. Answer: Relational database stores metadata for
projects and folders
⩥ Projects. Answer: Highest level container that organized objects and
processes also containing nested folders
⩥ Read Permission. Answer: Execute rules, export data and export rules
⩥ Write Permission. Answer: Delete or edit the project
,⩥ Grant Permission. Answer: Execute rules, export data, export rules
and contains the ability to assign others tasks
⩥ Logical Data Object. Answer: Regular object combining the can
combine data sources behind the scenes and provide one view
⩥ Content Set. Answer: Model Repository Object used to store reusable
content
⩥ Aggregator Transformation. Answer: Perform aggregate calculations
⩥ Custom Data Transformation. Answer: Processes data in unstructured
/ semi-structured file formats
⩥ Expressions Transformation. Answer: Performs low level calculations
⩥ Filter Transformation. Answer: Used as condition statement for
inclusion
⩥ Java Transformation. Answer: Allows Java syntax to be used in
Informatica
, ⩥ Joiner Transformation. Answer: Joins heterogeneous sources
⩥ Router Transformation. Answer: Routes rows conditionally
⩥ Rank Transformation. Answer: Sets the condition for rows included in
a rank
⩥ Sorter Transformation. Answer: Used to sort data
⩥ Union Transformation. Answer: Performs union all join between two
data streams
⩥ Update Strategy Transformation. Answer: Tags rows as insert update
delete or reject
⩥ Read Transformation. Answer: Reads from Logical Data Objects
⩥ Write Transformation. Answer: Writes to Logical Data Objects
⩥ Lookup Transformation. Answer: Looks up values and passes them to
other objects
⩥ Case Transformation. Answer: Changes case of data
2026 COMPLETE QUESTIONS WITH
VERIFIED SOLUTIONS
⩥ Mapplet. Answer: Reusable predefined process containing
transformations
⩥ Transformation. Answer: Objects used to transform data
⩥ Ports. Answer: Input or output fields
⩥ Strategy. Answer: Operation that is applied to data in a transformation
⩥ Profiling. Answer: Analysis of the content and structure of data
⩥ Transformation Pallet. Answer: All transformations displayed in scroll
bar on the left hand side
⩥ Mainline Editor. Answer: Where mappings, profiles, workflows are
created. Where transformations are placed
,⩥ Outline. Answer: Shows dependencies of an object, this can be a
transformation or rule
⩥ Object Explorer. Answer: Shows model repository, projects, folders
and data objects
⩥ Properties. Answer: Shows configurations for transformations or
mapplets / mappings
⩥ Data Viewer. Answer: Runs data through mapping and displays it.
⩥ Cheat Sheets. Answer: Provides step by step guide for a process or
transformation configuration guide
⩥ Model Repository. Answer: Relational database stores metadata for
projects and folders
⩥ Projects. Answer: Highest level container that organized objects and
processes also containing nested folders
⩥ Read Permission. Answer: Execute rules, export data and export rules
⩥ Write Permission. Answer: Delete or edit the project
,⩥ Grant Permission. Answer: Execute rules, export data, export rules
and contains the ability to assign others tasks
⩥ Logical Data Object. Answer: Regular object combining the can
combine data sources behind the scenes and provide one view
⩥ Content Set. Answer: Model Repository Object used to store reusable
content
⩥ Aggregator Transformation. Answer: Perform aggregate calculations
⩥ Custom Data Transformation. Answer: Processes data in unstructured
/ semi-structured file formats
⩥ Expressions Transformation. Answer: Performs low level calculations
⩥ Filter Transformation. Answer: Used as condition statement for
inclusion
⩥ Java Transformation. Answer: Allows Java syntax to be used in
Informatica
, ⩥ Joiner Transformation. Answer: Joins heterogeneous sources
⩥ Router Transformation. Answer: Routes rows conditionally
⩥ Rank Transformation. Answer: Sets the condition for rows included in
a rank
⩥ Sorter Transformation. Answer: Used to sort data
⩥ Union Transformation. Answer: Performs union all join between two
data streams
⩥ Update Strategy Transformation. Answer: Tags rows as insert update
delete or reject
⩥ Read Transformation. Answer: Reads from Logical Data Objects
⩥ Write Transformation. Answer: Writes to Logical Data Objects
⩥ Lookup Transformation. Answer: Looks up values and passes them to
other objects
⩥ Case Transformation. Answer: Changes case of data
