Using the Properties view of a Session task from the Workflow Monitor, the reason for a session’s failure can possibly be determined? A. True B. False
Which one of the following transformations may be unconnected In a valid mapping? (choose one) A. Lookup, stored procedure, external procedure B. Lookup, stored procedure, Java C. Java, lookup, transaction control D. Transaction control, Java, lookup
A user needs to compare mappings across two folders using the comparsion tool in PowerCenter Designer. What does the user account need in order to successfully complete the comparsion action? (Given that the user account has been granted the ability…
Given a Union transformation with 2 input groups, which statement is correct and true? A. Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups. B. Either input group can have…
When the Transformation Scope is set to All Input, which group of transformations listed below will always cause an upstream Transaction Control transformation to become ineffective? (choose one) A. Filter, Joiner, Rank B. Union, Filter, Aggregator C. Rank, Lookup, Aggregator…
The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator transformation? A. Pass-through B. Hash auto-keys C. Not a valid partition points D. Based…
Which of the following is a reusable task available in workflow manager? A. Decision B. Assignment C. Control D. Command
What is a pipeline lookup transformation? A. A lookup created using a pipeline which contains a target B. A lookup cache split over pipelines of a partitioned mapping C. A lookup associated with the Source Qualifier or an Application source…
Which command line tool would you use to execute a workflow? A. infasetup B. infacmd C. pmcmd D. pmrep
Which is the correct priority of assigning a mapping variable? A. Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value B. Session parameter file, workflow parameter file, repository value, declared initial value C. Repository…