Informatica PR000041 Online Practice Questions and Exam Preparation

Informatica PR000041 Online Questions & Answers

• Question 1:

  In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)

  A. Character day of week, character day of month, and character day of year respectively
  B. Day of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively
  C. Each produces numerical day of week
  D. Numerical day of week, day of month, and day of year respectively
  D. Numerical day of week, day of month, and day of year respectively

• Question 2:

  Transformation: Referring to Active and Passive characteristics - Select the statement which is correct and true.

  A. If a transformation's Active property is cleared or not enabled, the transformation becomes passive
  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
  D. A passive transformation will not change the number of rows in the pipeline

• Question 3:

  Please choose one of the following. In a static, non-multi-row lookup,

  A. lf a lookup search does not find a value in the search data, then the row from which the search is produced is dropped so a balanced pipeline can be produced
  B. If a lookup search finds the search value in the lookup data but discovers that the fields that are being returned from the search are null, then the row from which the search is produced is dropped so that a balanced pipeline can be produced
  C. If the lookup finds two records that match the search key, it will return two records
  D. None of the above
  D. None of the above

• Question 4:

  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
  B. The lookup index cache file contains a searchable index of the records based on the lookup condition

• Question 5:

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

  A. True
  B. False
  B. False

• Question 6:

  Which one of the following transformations may be unconnected In a valid mapping? (choose one)

  A. Lookup, stored procedure, external procedure
  B. Lookup, stored procedure, Java
  C. Java, lookup, transaction control
  D. Transaction control, Java, lookup
  A. Lookup, stored procedure, external procedure

• Question 7:

  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
  A. The Integration Service starts a JVM that executes the byte code to process data

• Question 8:

  If after running a session task, it has been determined that the incorrect mapping was run for that session task, which of the following actions could be attempted?

  A. Edit the session task and from the General tab, choose the correct mapping to reassociate with the session task, then Save and rerun the process
  B. At run time, when the workflow is executed, chose the session task with the correct mapping associated
  C. Edit the session task and from the Mapping tab, choose the correct mapping to reassociate with the session ask, then Save and rerun the process
  D. None of the above
  A. Edit the session task and from the General tab, choose the correct mapping to reassociate with the session task, then Save and rerun the process

• Question 9:

  What is a pipeline lookup transformation?

  A. A lookup created using a pipeline which contains a target
  B. A lookup cache split over pipelines of a partitioned mapping
  C. A lookup associated with the Source Qualifier or an Application source such as JMS or SAP
  D. A pipeline lookup does not exist
  C. A lookup associated with the Source Qualifier or an Application source such as JMS or SAP

• Question 10:

  Referring to Informatica Domain Architecture, select the statement which is correct and true.

  A. A worker node does not use a service manager
  B. The OS process that is running after the service manager is started is called pmserver
  C. The service manager on node 1 will directly monitor services on node 1 and node 2. This is why it is called the gateway manager.
  D. Nodes within a domain are identified by their name, a hostname and portnumber
  B. The OS process that is running after the service manager is started is called pmserver