Informatica PR000041 Online Practice Questions and Exam Preparation

Informatica PR000041 Online Questions & Answers

• Question 41:

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

  A. True
  B. False
  A. True

• Question 42:

  An Unconnected Stored Procedure can run in the following fashions?(Choose all that apply) Choose 3 answers

  A. From an expression
  B. As a Post-Session SQL command
  C. As a Pre-Session SQL command
  D. As the only object In the mapping
  A. From an expression
  B. As a Post-Session SQL command
  C. As a Pre-Session SQL command

• Question 43:

  Which of the following is true about database connections?

  A. Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS
  B. PowerCenter connections may be created In either the Administrator or the Workflow Manager
  C. MRS connections may be created in either the Workflow Manager or the Administrator
  D. Connections may be created in the Administrator for the MRS and in the Workflow Manager for PowerCenter Repositories
  A. Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS

• Question 44:

  What is the first column of the bad file?

  A. Reject reason
  B. Column Indicator
  C. Overflow Indicator
  D. Row Indicator
  D. Row Indicator

• Question 45:

  A Router transformation has the following group filter conditions: Group A: InputValue = 2

  Group B: InputValue > 1

  Default group

  The InputValue Is an integer port. Identify which of the following statements is correct. (Choose one)

  A. If InputValue = 2, the output will be routed to Group A only
  B. If InputValue = 2, the output will be routed to both groups A and B
  C. If InputValue = 2, the router will fail, since rows cannot be routed to multiple groups
  D. Any positive number values other than 1 or 2 will be routed to the Default group
  B. If InputValue = 2, the output will be routed to both groups A and B

• Question 46:

  The HTTP Transformation supports which HTTP Methods? (Choose all that apply) Choose 2 answers

  A. DELETE
  B. GET
  C. POST
  D. PUT
  B. GET
  C. POST

• Question 47:

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

  A. Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.
  B. 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.
  C. When merging the 2 groups of data together, the Union transformation will remove duplicate rows.
  D. The port names in each input group can be named the same.
  A. Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.

• Question 48:

  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
  B. The data from the master pipeline is used to build the cache files used in the join process

• Question 49:

  In the Expression transformation graphic below, what is the value of the PREVIOUS_STATE port for row 2, given that the value for the STATE port was 'CA' for row 1?

  

  A. STATE
  B. 'CA'
  C. NULL
  D. Value of the PREVI0US_STATE port is based upon its declared default value
  B. 'CA'

• Question 50:

  What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression?

  functionname{1, COMPANY, 'i' , 'I')

  A. CHOOSE
  B. REPLACECHR
  C. REG_REPLACE
  D. INSTR
  B. REPLACECHR