PR000041 Online Practice Questions and Answers
Which of following statements is valid for Dynamic lookups?
A. Dynamic caching cannot be enabled on a lookup that returns multiple rows per search
B. A dynamic lookup can only be used with insert mappings, i.e. no update strategies are allowed and the session should be configured as Insert
C. A dynamic lookup must be cached and persistent
D. It is possible to update and delete records in a dynamic lookup
Which one of the following transformations may be unconnected In a valid mapping? (choose one)
A. Lookup, stored procedure, external procedure
B. Lookup, stored procedure, Java
C. Java, lookup, transaction control
D. Transaction control, Java, lookup
Using the Properties view of a Session task from the Workflow Monitor, the reason for a session's failure can possibly be determined?
A. True
B. False
Referring to Informatica Domain Architecture, select the statement which is correct and true.
A. A worker node does not use a service manager
B. The OS process that is running after the service manager is started is called pmserver
C. The service manager on node 1 will directly monitor services on node 1 and node 2. This is why it is called the gateway manager.
D. Nodes within a domain are identified by their name, a hostname and portnumber
Which command line tool would you use to import a workflow into a repository?
A. Infasetup
B. infacmd
C. pmcmd
D. pmrep
How does a single joiner transformation join data?
A. From 2 pipeline inputs
B. From 3 pipeline inputs
C. From n number of pipeline inputs assuming you have purchased the N-Joiner Option
D. none of the above
Please choose one of the following. In a static, non-multi-row lookup,
A. 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
B. 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
C. If the lookup finds two records that match the search key, it will return two records
D. None of the above
By default workflows always have a run status of succeeded. Identify the methods to change the run status of the workflow. For the puposes of this question, assume there are no worklets in the workflow.
A. Check the Fail Parent if this task fails option box on the session task
B. Use a Control Task with a Control Option setting of Fail Me
C. Use an assignment task to call the ERROR() function
D. Use a command task to set the value of $RC to a negative number
When using the Joiner transformation and assuming that you are not employing the Push Down Optimization feature, which statement is correct?
A. The data from the detail pipeline Is used to build the cache files used In the join process
B. The data from the master pipeline is used to build the cache files used in the join process
C. The cache files are built according to a sql override found on the Joiner Properties tab
D. The Joiner transformation uses the database to build the join result
A Router transformation has the following group filter conditions:
Group A: InputValue = 2
Group B: InputValue > 1
Default group
The InputValue Is an integer port. Identify which of the following statements is correct. (Choose one)
A. If InputValue = 2, the output will be routed to Group A only
B. If InputValue = 2, the output will be routed to both groups A and B
C. If InputValue = 2, the router will fail, since rows cannot be routed to multiple groups
D. Any positive number values other than 1 or 2 will be routed to the Default group