CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Informatica
  5. PR000041

Free PR000041 Exam Braindumps (page: 4)

Page 3 of 18
PDF with 70 Questions

Which of following statements is valid for Dynamic lookups?

  1. Dynamic caching cannot be enabled on a lookup that returns multiple rows per search
  2. A dynamic lookup can only be used with insert mappings, i.e. no update strategies are allowed and the session should be configured as Insert
  3. A dynamic lookup must be cached and persistent
  4. It is possible to update and delete records in a dynamic lookup

Answer(s): A



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?

  1. STATE
  2. 'CA'
  3. NULL
  4. Value of the PREVI0US_STATE port is based upon its declared default value

Answer(s): B



What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression?
functionname{1, COMPANY, 'i' , 'I')

  1. CHOOSE
  2. REPLACECHR
  3. REG_REPLACE
  4. INSTR

Answer(s): B



Which port types are applicable to the Stored Procedure transformation?(Choose all that apply) Choose 3 answers

  1. lnput
  2. Output
  3. Variable
  4. Return

Answer(s): A,B,D






Post your Comments and Discuss Informatica PR000041 exam with other Community members:

PR000041 Discussions & Posts