Informatica PR000041 Exam Questions & Answers

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

Which of these statements is correct concerning a Lookup transformation's persistent cache?

A. A persistent cache is stored on disk, and must be named to make it useable in multiple mappings

B. persistent cache is stored on disk, to refresh the cache the disk files must be deleted manually

C. When the Integration Service cannot find the persistent cache file and the recache property is not set, the session fails

D. A persistent cache can only be used by one mapping

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