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

Referring to the Java transformation: select the statement below which is correct and true.

• A.The Integration Service starts a JVM that executes the byte code to process data
• B.No Third Party Java API's are supported in the Java transformation
• C.The Java transformation icon in PowerCenter Designer resembles a coffee bean
• D.PowerCenter requires an Eclipse Java Development Environment for the Java transformation

When using the Joiner transformation and assuming that you are not employing the Push Down Optimization feature, which statement is correct?

• A.The cache files are built according to a sql override found on the Joiner Properties tab
• B.The Joiner transformation uses the database to build the join result
• C.The data from the detail pipeline Is used to build the cache files used In the join process
• D.The data from the master pipeline is used to build the cache files used in the join process

The constant DD_INSERT may be used in an expression within which transformation or transformations? (choose one)

• A.Update Strategy
• B.Expression, Aggregator, and Update Strategy
• C.Expression and Update Strategy
• D.Update Strategy and Lookup

Referring to a lookup transformation: Which of the following statements are true and correct?

• A.The caching of a flat file is optional if the data in the flat file is sorted
• B.The lookup index cache file contains a searchable index of the records based on the lookup condition
• C.The data cache contains all of the fields in the lookup transformation
• D.When lookup caching is unchecked, PowerCenter will read from a locally stored cache file

Which of the following Is NOT true of Aggregate functions?

• A.You can calculate a single value for all rows in a group
• B.You can add a filter condition to calculate values for specific rows In the selected ports
• C.You can use operators to perform arithmetic within the function
• D.You can place an aggregate function in a variable port