Data Quality 10: Developer Specialist Exam
Which of the following is true about database connections?
Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS
PowerCenter connections may be created In either the Administrator or the Workflow Manager
MRS connections may be created in either the Workflow Manager or the Administrator
Connections may be created in the Administrator for the MRS and in the Workflow Manager for PowerCenter Repositories
Which of the following techniques could be used to filter data read from a flat file source?
Create a valid condition in the Filter attribute of the flat file's Source Qualifier
Place a Filter transformation directly after the flat file's Source Qualifier
An Expression transformation with an output port's expression defined to filter records
An Expression transformation with all of the output port's default values set to blank
Can you use a Decode function to perform multiple searches based on a single search value?
No
Yes
Yes, but only if the port being searched Is sorted first
Yes, but only if the port is downstream of a router transformation