Free Informatica PR000041 Exam Dumps Questions & Answers

Assuming that the Master Pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation, how many fields are in the index and data cache files?

• A.  2 fields are in the index and 5 fields are in the data cache
• B.  5 fields are in the index cache and 3 are in the data cache
• C.  2 fields are in the index cache and 3 fields are in the data cache
• D.  3 fields are in the index cache and 2 fields are in the data cache

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

• A.  If the lookup finds two records that match the search key, it will return two records
• B.  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
• C.  None of the above
• D.  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

When would a Lookup transformation be classified as active?

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

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 Sequence Generator contains a single input port that represents the initial starting point of the sequence
• D.  The default ending value for a PowerCenter 9.x Sequence Generator is 2,147,483,647

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

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