Informatica Desingner Certification
Settings
Desingner Certification
- 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.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
- 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
- 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
- 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.
Back to top