PR000041 무료 덤프문제 온라인 액세스

What function would transform 12.99 to 13.0 and 15.44 to 15.4? (choose one)

• A.CONCAT
• B.INSTR
• C.ROUND
• D.TRUNC

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

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

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.Rank, Lookup, Aggregator
• B.Filter, Joiner, Rank
• C.Joiner, Rank, Sorter
• D.Union, Filter, Aggregator

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

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 SQL UNION operation
• B.This picture depicts a join that will be processed in a database
• C.This picture depicts an Informatica Homogeneous Join
• D.This picture depicts a join that will be processed within the Informatica PowerCenter engine