Informatica PR000041 Online Practice Questions and Exam Preparation

Informatica PR000041 Online Questions & Answers

• Question 61:

  Which of the following is not a Transaction Control Variable?

  A. TC_CONTINUE_TRANSCTION
  B. TC_COMMIT_TRANSACTION
  C. TC_ROLLBACK_BEFORE
  D. TC COMMIT AFTER
  B. TC_COMMIT_TRANSACTION

• Question 62:

  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
  B. Records that are tagged for rejection are dropped and not projected downstream to the next transformation

• Question 63:

  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. Option B
  C. Option C
  D. Option D
  A. Option A
  C. Option C

• Question 64:

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

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

• Question 65:

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

  A. The NextVal column produces the next number in the sequence
  B. 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
  C. The default ending value for a PowerCenter 9.x Sequence Generator is 2,147,483,647
  D. The Sequence Generator contains a single input port that represents the initial starting point of the sequence
  A. The NextVal column produces the next number in the sequence

• Question 66:

  Which command line tool would you use to execute a workflow?

  A. infasetup
  B. infacmd
  C. pmcmd
  D. pmrep
  C. pmcmd

• Question 67:

  Which of the following are supported file types, from which, an XML definition can be imported? Choose 3 answers

  A. XML
  B. XSD
  C. DTD
  D. DSDL
  A. XML
  B. XSD
  C. DTD

• Question 68:

  Which of these statements on worklets is correct?

  A. Worklets can be nested
  B. A worklet must be a reusable object
  C. A worklet can be executed separately
  D. A worklet does not have to contain a Start task
  A. Worklets can be nested

• Question 69:

  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
  B. A mapplet can contain a source definition as well as a source qualifier

• Question 70:

  When would a Lookup transformation be classified as active?

  A. When the setting for lookup policy on multiple match is Use Any Value
  B. A lookup cannot be an active transformation
  C. When the lookup is configured to return multiple rows
  D. A lookup is always active
  C. When the lookup is configured to return multiple rows