Free Access to Informatica.PR000041.v2022-09-30.q49 with Valid Practice Test (Page 6)

Question 21

Given this picture of a PowerCenter Mapping and assuming there is no SQL override in the Source Qualifier:

Identify all of the true and correct statements listed below. Choose 2 answers

A.This picture depicts a join that will be processed within the Informatica PowerCenter engine
B.This picture depicts a join that will be processed in a database
C.This picture depicts a SQL UNION operation
D.This picture depicts an Informatica Homogeneous Join

Question 22

Given a Union transformation with 2 input groups, which statement is correct and true?

A.When merging the 2 groups of data together, the Union transformation will remove duplicate rows.
B.The port names in each input group can be named the same.
C.Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.
D.Either input group can have a port that does not match the other input group. The precision, datatype, and scale does not have to be identical across both input groups.

Question 23

Can you use a Decode function to perform multiple searches based on a single search value?

A.Yes, but only if the port being searched Is sorted first
B.Yes, but only if the port is downstream of a router transformation
C.Yes
D.No

Question 24

From within your folder, is it possible to make a non-reusable copy of a reusable transformation for use in a mapping?

A.No
B.Yes, by dragging the reusable object into your mapping and unchecklng the Reusable checkbox
C.Yes, by first selecting the reusable object and while dragging the object into your mapping, hold the Ctrl key down
D.Yes' by first clicking the Ctrl key and then dragging the reusable object into the mapping

Question 25

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

Question 21

Question 22

Question 23

Question 24

Question 25

Download PDF File