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 an Informatica Homogeneous Join
• 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 a join that will be processed within the Informatica PowerCenter engine

Comment: *

Name: *

Email: *

Verification: *

Referring to the Sequence Generator transformation, which statement is correct and true?

• A.The cycle check box on the properties tab turns on a feature that randomizes the numbers but still produces a unique set of numbers for the sequence
• B.The Sequence Generator contains a single input port that represents the initial starting point of the sequence
• C.The NextVal column produces the next number in the sequence
• D.The default ending value for a PowerCenter 9.x Sequence Generator is 2,147,483,647

Comment: *

Name: *

Email: *

Verification: *

An Update Strategy transformation has the Forward Rejected Rows attribute unchecked. Which statement is correct and true?

• A.Records that are tagged for rejection are dropped and not projected downstream to the next transformation
• B.The Forward Rejected Rows attribute cannot be cleared after the transformation is created
• C.Records that are tagged for rejection are projected downstream to the next transformation so long as the ports are connected properly
• D.The Forward Rejected Rows attribute is only applicable when records are tagged for rejection upstream of the Update Strategy transformation

Comment: *

Name: *

Email: *

Verification: *

Referring to an Unconnected Lookup transformation: Which one of the following is true? (choose one)

• A.Both connected and unconnected lookups can return multiple rows
• B.An unconnected lookup may return only one value while a connected lookup may return multiple rows
• C.Both connected and unconnected lookups can return only one row
• D.An unconnected lookup can return multiple rows while a connected lookup may return only one

Comment: *

Name: *

Email: *

Verification: *

In which of the following selections are all of the transformations active?

• A.Expression, Router, Joiner
• B.Stored Procedure, Joiner, Router
• C.Update Strategy, Expression, Aggregator
• D.Router, Update Strategy, Joiner

Comment: *

Name: *

Email: *

Verification: *