Free Informatica PR000041 Exam Dumps Questions & Answers

A workflow has a session task. Both workflow and session each have been assigned a different parameter file. Which value will be set for $$ParameterValue in the session when using the following two parameter files?"
Workflow Parameter file:
[Global] $$ParameterValue=l
[Session] $$ParameterValue=2
Session Parameter file:
[Global] $$ParameterValue=3
[Session] $$ParameterValue=4

• A.  1
• B.  4
• C.  3
• D.  2

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.  3 fields are in the index cache and 2 fields are in the data cache
• B.  2 fields are in the index and 5 fields are in the data cache
• C.  2 fields are in the index cache and 3 fields are in the data cache
• D.  5 fields are in the index cache and 3 are in the data cache

Which of the following statements is correct on workflow events?

• A.  A user-defined event can be created in either the Event Wait or Event Raise task
• B.  A predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping
• C.  A user-defined event can be created a-d raised in one workflow and then used In another
• D.  A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon as the file appears, it is deleted and the subsequent task will start.

Which port types are applicable to the Stored Procedure transformation?(Choose all that apply) Choose 3 answers

• A.  lnput
• B.  Return
• C.  Variable
• D.  Output

Which of the following statments are valid for Active and Passive Transformations? Choose 2 answers

• A.  A passive transformation will not change the number of rows in the pipeline
• B.  Transformations can be active and passive at the same time
• C.  A transformation is active if It rearranges the order of the rows in the pipeline
• D.  A transformation is active if it does not change the number of rows in the pipeline