Informatica Desingner Certification

6 Questions | By Afzal.pathan | Updated: Mar 15, 2022 | Attempts: 985

Questions

Settings

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

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
Correct Answer
A. The mapping will be valid as it is.
2.

Input transformation in mappletSelect the statement below that is true.
- 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
Correct Answer
B. A mapplet that does not contain an Input transformation is an active mapplet only if it contains at least one active transformation.
3.

How many Output transformations can be placed in a mapplet?
- 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
Correct Answer
B. One or more
4.

Homogeneous Source DefinitionsHow many homogeneous Source Definitions can be placed in a Mapplet?
- 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
Correct Answer
B. One for each Source Qualifier transformation.
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
Correct Answer
A. True
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.
Correct Answer
B. It is dropped from the mapping flow and written to the appropriate reject (bad) file.

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 15, 2022

Quiz Edited by
ProProfs Editorial Team
Nov 24, 2009

Quiz Created by
Afzal.pathan

Informatica Desingner Certification

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.

Input transformation in mappletSelect the statement below that is true.

How many Output transformations can be placed in a mapplet?

Homogeneous Source DefinitionsHow many homogeneous Source Definitions can be placed in a Mapplet?

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)

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?