MDX QUERY SPECIALIST EXAM
ACTUAL EXAM
Mapping - CORRECT ANSWERS-Defines the flow and
transformation of data
Mapplet - CORRECT ANSWERS-Reusable predefined process
containing transformations
Transformation - CORRECT ANSWERS-Objects used to
transform data
Ports - CORRECT ANSWERS-Input or ...
,Mapping - CORRECT ANSWERS-Defines the flow and
transformation of data
Mapplet - CORRECT ANSWERS-Reusable predefined process
containing transformations
Transformation - CORRECT ANSWERS-Objects used to
transform data
Ports - CORRECT ANSWERS-Input or output fields
Strategy - CORRECT ANSWERS-Operation that is applied to
data in a transformation
Profiling - CORRECT ANSWERS-Analysis of the content and
structure of data
Transformation Pallet - CORRECT ANSWERS-All
transformations displayed in scroll bar on the left hand side
Mainline Editor - CORRECT ANSWERS-Where mappings,
profiles, workflows are created. Where transformations are placed
Outline - CORRECT ANSWERS-Shows dependencies of an
object, this can be a transformation or rule
Object Explorer - CORRECT ANSWERS-Shows model
repository, projects, folders and data objects
Properties - CORRECT ANSWERS-Shows configurations for
transformations or mapplets / mappings
Data Viewer - CORRECT ANSWERS-Runs data through
mapping and displays it.
Cheat Sheets - CORRECT ANSWERS-Provides step by step
guide for a process or transformation configuration guide
,Model Repository - CORRECT ANSWERS-Relational database
stores metadata for projects and folders
Projects - CORRECT ANSWERS-Highest level container that
organized objects and processes also containing nested folders
Read Permission - CORRECT ANSWERS-Execute rules, export
data and export rules
Write Permission - CORRECT ANSWERS-Delete or edit the
project
Grant Permission - CORRECT ANSWERS-Execute rules, export
data, export rules and contains the ability to assign others tasks
Logical Data Object - CORRECT ANSWERS-Regular object
combining the can combine data sources behind the scenes and
provide one view
Content Set - CORRECT ANSWERS-Model Repository Object
used to store reusable content
Aggregator Transformation - CORRECT ANSWERS-Perform
aggregate calculations
Custom Data Transformation - CORRECT ANSWERS-Processes
data in unstructured / semi-structured file formats
Expressions Transformation - CORRECT ANSWERS-Performs
low level calculations
Filter Transformation - CORRECT ANSWERS-Used as condition
statement for inclusion
Java Transformation - CORRECT ANSWERS-Allows Java syntax
to be used in Informatica
Joiner Transformation - CORRECT ANSWERS-Joins
heterogeneous sources
, Router Transformation - CORRECT ANSWERS-Routes rows
conditionally
Rank Transformation - CORRECT ANSWERS-Sets the condition
for rows included in a rank
Sorter Transformation - CORRECT ANSWERS-Used to sort data
Union Transformation - CORRECT ANSWERS-Performs union all
join between two data streams
Update Strategy Transformation - CORRECT ANSWERS-Tags
rows as insert update delete or reject
Read Transformation - CORRECT ANSWERS-Reads from
Logical Data Objects
Write Transformation - CORRECT ANSWERS-Writes to Logical
Data Objects
Lookup Transformation - CORRECT ANSWERS-Looks up values
and passes them to other objects
Case Transformation - CORRECT ANSWERS-Changes case of
data
Merge Transformation - CORRECT ANSWERS-Concatenates
values
Address Validator Transformation - CORRECT ANSWERS-
Examines input addresses and outputs corrected address
elements and validation information
Association Transformation - CORRECT ANSWERS-Creates
links between records assigned to different match clusters so they
can be associated for consolidation
Comparison Transformation - CORRECT ANSWERS-Evaluates
similarity between pairs of input values
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller jackwa. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $21.99. You're not tied to anything after your purchase.
