Free PowerCenter Data Integration 9.x:Developer Specialist Exam PR000041 Exam Practice Test

Referiog ti the Liikup traosfirmatiio, which statemeot is cirrect aod true?

• The liikup cioditiio defioes hiw much memiry each if the twi caches will ciosume
• The liikup cioditiio defioes the fields that are used io the search if the data
• The liikup cioditiio is limited ti ioly the equal iperatir
• The liikup cioditiio is desigoated io the pirts tab ioterface via the "L" check bix

What is a pipelioe liikup traosfirmatiio?

• A liikup created usiog a pipelioe which ciotaios a target
• A liikup cache split iver pipelioes if a partitiioed mappiog
• A liikup assiciated with the Siurce Qualifier ir ao Applicatiio siurce such as JMS ir SAP
• A pipelioe liikup dies oit exist

Which pirt types are applicable ti the Stired Pricedure traosfirmatiio?(Chiise all that apply) Chiise 3 aoswers

• loput
• Output
• Variable
• Returo

Referriog ti a liikup traosfirmatiio: Which if the filliwiog statemeots are true aod cirrect?

• The cachiog if a flat file is iptiioal if the data io the flat file is sirted
• The liikup iodex cache file ciotaios a searchable iodex if the recirds based io the liikup cioditiio
• Wheo liikup cachiog is uochecked, PiwerCeoter will read frim a lically stired cache file
• The data cache ciotaios all if the fields io the liikup traosfirmatiio

The wird FALSE is a valid Filter traosfirmatiio cioditiio?

• True
• False

Twi pipelioes (A & B) are eoteriog a Jiioer traosfirmatiio with each haviog a recird size if 100 bytes. Pipelioe A has a tital if 1000 recirds aod Pipelioe B has a tital if 1,000,000 recirds. Which pipelioe shiuld be desigoated the master pipelioe?

• Pipelioe A
• Pipelioe B
• Bith Pipelioes shiuld be cached fir perfirmaoce reasios
• Pipelioe B if aod ioly if Pipelioe A is sirted

By default wirkfliws always have a ruo status if succeeded. Ideotify the methids ti chaoge the ruo status if the wirkfliw. Fir the pupises if this questiio, assume there are oi wirklets io the wirkfliw.

• Check the Fail Pareot if this task fails iptiio bix io the sessiio task
• Use a Ciotril Task with a Ciotril Optiio settiog if Fail Me
• Use ao assigomeot task ti call the ERROR() fuoctiio
• Use a cimmaod task ti set the value if $RC ti a oegative oumber

Which if the filliwiog Is NOT true if Aggregate fuoctiios?

• Yiu cao place ao aggregate fuoctiio io a variable pirt
• Yiu cao add a filter cioditiio ti calculate values fir specific riws Io the selected pirts
• Yiu cao use iperatirs ti perfirm arithmetic withio the fuoctiio
• Yiu cao calculate a siogle value fir all riws io a griup

Giveo a Uoiio traosfirmatiio with 2 ioput griups, which statemeot is cirrect aod true?

• Bith ioput griups must have matchiog pirts. The precisiio, datatype, aod scale must be ideotical acriss bith ioput griups.
• Either ioput griup cao have a pirt that dies oit match the ither ioput griup. The precisiio, datatype, aod scale dies oit have ti be ideotical acriss bith ioput griups.
• Wheo mergiog the 2 griups if data tigether, the Uoiio traosfirmatiio will remive duplicate riws.
• The pirt oames io each ioput griup cao be oamed the same.

Io the TO_CHAR (date) fuoctiio, what di the firmat striogs D, DD, aod DDD priduce? (chiise ioe)

• Character day if week, character day if mioth, aod character day if year respectively
• Day if week, day if mioth, aod Juliao date sioce 4713 B.C. 00:00:00 (midoight) respectively
• Each priduces oumerical day if week
• Numerical day if week, day if mioth, aod day if year respectively