Informatica Desingner Certification

6 Questions

Settings
IT Certification Quizzes & Trivia

Desingner Certification


Questions and Answers
  • 1. 
    Mapplet definitionRefer to the mapping illustrated below. Assume that the mapplet definition is valid and that the individual transformation expressions are valid. Select the statement that is correct.
    • A. 

      The mapping will be valid as it is.

    • B. 

      The mapping is valid because the third mapplet output group, Update Changes, does not have any output ports connected to a transformation or Target definition.

    • C. 

      The mapping is invalid because you cannot concatenate two or more data flow paths together into one mapplet input group.

    • D. 

      The mapplet is invalid because the number of output ports in each output group does not match. Input transformation in mapplet

  • 2. 
    • A. 

      A mapplet that does not contain an Input transformation is always an active mapplet.

    • B. 

      A mapplet that does not contain an Input transformation is an active mapplet only if it contains at least one active transformation.

    • C. 

      A passive mapplet can be made into an active mapplet by adding one or more Joiner transformations to the mapplet.

    • D. 

      A passive mapplet can be made into an active mapplet by adding one or more Lookup transformations to the mapplet. Output transformations in a mapplet

  • 3. 
    • A. 

      One

    • B. 

      One or more

    • C. 

      One or more unless there is at least one Target definition in the mapplet, in which case zero Output transformations are permitted.

    • D. 

      Any number

  • 4. 
    • A. 

      One

    • B. 

      One for each Source Qualifier transformation.

    • C. 

      Zero to one if the mapplet does not contain an Input or ERP Source Qualifier transformation.

    • D. 

      Unlimited

  • 5. 
    Difference between the Router and Filter transformationsA major difference between the Router and Filter transformations is that filtered rows can be captured in the Router. (T/F)
    • A. 

      True

    • B. 

      False

  • 6. 
    Filter transformationA Filter transformation contains the following condition: ITEM_COST > 100.00. The value for ITEM_COST for a specific row is 35. What will happen to that row?
    • A. 

      It is dropped from the mapping flow.

    • B. 

      It is dropped from the mapping flow and written to the appropriate reject (bad) file.

    • C. 

      It is dropped from the mapping flow and written to the appropriate reject (bad) file if the Filter property "Forward Filtered Rows" is set to True.

    • D. 

      If the Filter property "Forward Filtered Rows" is set to True, the row is sent to downstream transformations, if any, but not written to the target table.