PowerCenter Data Integration 9.x:Developer Specialist v6.0 (PR000041)

Page:    1 / 5   
Total 76 questions

Which of the following statements regarding mapplets are correct and true?

  • A. A mapplet can contain a target definition
  • B. A mapplet can contain a source definition as well as a source qualifier
  • C. Every mapplet must have at least 1 Input transformation as well as 1 Output transformation
  • D. A mapplet can contain a Normalizer transformation


Answer : B

Which of the following statments are valid for Active and Passive Transformations? Choose
2 answers

  • A. A transformation is active if It rearranges the order of the rows in the pipeline
  • B. A transformation is active if it does not change the number of rows in the pipeline
  • C. Transformations can be active and passive at the same time
  • D. A passive transformation will not change the number of rows in the pipeline


Answer : A,D

A Pipeline Normalizer transformation will reflect one input port for each occurs value which
Is greater than 1.

  • A. True
  • B. False


Answer : A

Assuming that the value of Fl is 12 as it enters the decode statement, which of the following decode statements will produce the value V?Choose 2 answers

  • A. Option A
  • B. OptionB
  • C. OptionC
  • D. OptionD


Answer : A,C

The Informatics Date/Time datatype supports values up to which level? (choose one)

  • A. Picosecond
  • B. Microsecor|d
  • C. Nanosecond
  • D. Millisecond


Answer : C

Regarding the Sorter transformation and assuming that Powercenter is not utilizing
Pushdown Optimization, select the statement which is correct and true:

  • A. When the distinct check box is selected, every port in the sorter transformation will have the sort key selection enabled
  • B. When transformation scope is set to a value of transaction, the sorter will sort on every record in the pipeline before it releases any data. The intermediate sort file will have markers for each transaction.
  • C. If the distinct check box is not checked, the sorter will produce one record per unique key
  • D. The Sorter transformation will utilize database indexes from the source database to perform the sort


Answer : A

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. When lookup caching is unchecked, PowerCenter will read from a locally stored cache file
  • D. The data cache contains all of the fields in the lookup transformation


Answer : B

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

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


Answer : B

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. PowerCenter requires an Eclipse Java Development Environment for the Java transformation
  • C. No Third Party Java API's are supported in the Java transformation
  • D. The Java transformation icon in PowerCenter Designer resembles a coffee bean


Answer : A

Given the picture shown below:
How many columns would be selected from the database using PowerCenter's generated sql statement?

  • A. 2 -Due to the line on the left hand side of the picture
  • B. 13 -Based on all of the links entering the Source Qualifier
  • C. 3 -Based on the all of the links between the Source Qualifier and the next transformation
  • D. Unknown - We need to know how many columns the target has


Answer : C

What does the function SETVARIABLE($$Variable, value) do?

  • A. Assign the minimum value of the twoto $$Variable
  • B. Assign the maximum value of the two to $$Variable
  • C. Allows the assignment of a value to a parameter
  • D. Assign the value to $$Variable, unless the value is null


Answer : D

A workflow has a session task. Both workflow and session each have been assigned a different parameter file.Which value will be set for $$ParameterValue in the session when using the following two parameter files?"
Workflow Parameter file:
[Global] $$ParameterValue=l
[Session] $$ParameterValue=2
Session Parameter file:
[Global] $$ParameterValue=3
[Session] $$ParameterValue=4

  • A. 1
  • B. 2
  • C. 3
  • D. 4


Answer : A

Subqueries can be used in the SQL override for uncached lookup transformations.

  • A. True
  • B. False


Answer : B

Based upon the graphic below, which answer correctly discribes the outcome of this workflow's execution given the start method: (The workflow is valid)
Workflows > Start Workflow

  • A. AII objects displayed will be executed
  • B. The Start task only will be executed
  • C. The Start task and the link will execute, while the session task will wait to execute
  • D. The Start task and link only will be execute


Answer : D

Which attributes of a reusable Expression transformation can be edited within the Mapping
Designer workspace?

  • A. The transformation's name, one of its port's default values, the tracing level or a Metadata Extension
  • B. The transformation's name or the tracing level
  • C. The transformation's name, one of its port's default values or the tracing level
  • D. The transformation's name is the only attribute that can be changed


Answer : B

Page:    1 / 5   
Total 76 questions