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 command line tool would you use to execute a workflow?
A. infasetup
B. infacmd
C. pmcmd
D. pmrep
Given the picture shown below:
Identify all of the true and correct statements listed below. Note: The red (or gray) arrow points at the line in question.
The line on the left hand side of the picture which connects PRODUCT TO PRODUCT_COST : Choose 2 answers
A. Describes a LEFT OUTER JOIN between PRODUCT AND PRODUCT_COST
B. Describes an INNER JOIN between PRODUCT AND PRODUCT_COST
C. Describes a secondary data flow needed for a sub-select process between PRODUCT AND PRODUCT_COST
D. Can be created within Informatica PowerCenter
Two pipelines (A and B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?
A. Pipeline A
B. Pipeline B
C. Both Pipelines should be cached for performance reasons
D. Pipeline B if and only if Pipeline A is sorted
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
If after running a session task, it has been determined that the incorrect mapping was run for that session task, which of the following actions could be attempted?
A. Edit the session task and from the General tab, choose the correct mapping to reassociate with the session task, then Save and rerun the process
B. At run time, when the workflow is executed, chose the session task with the correct mapping associated
C. Edit the session task and from the Mapping tab, choose the correct mapping to reassociate with the session ask, then Save and rerun the process
D. None of the above
From within your folder, is it possible to make a non-reusable copy of a reusable transformation for use in a mapping?
A. Yes, by dragging the reusable object into your mapping and unchecklng the Reusable checkbox
B. Yes' by first clicking the Ctrl key and then dragging the reusable object into the mapping
C. Yes, by first selecting the reusable object and while dragging the object into your mapping, hold the Ctrl key down
D. No
Referring to the SQL Transformation: which statements is correct and true.
A. The SQL transformation in script mode can execute sql scripts containing individual select statements that return more than one record to the pipeline
B. The SQL transformation in query mode can execute multiple SQL statements where components of the SQL Statement can vary from one execution to the next
C. In PowerCenter 9 the SQL transformation, in query mode, can only be active
D. When you bind a parameter to an input port, you identify the port by name in the query. The SQL Editor encloses the name in exclamation question marks (!)
Referring to the Java transformation: select the statement below which is correct and true.
A. The Integration Service starts a JVM that executes the byte code to process data
B. PowerCenter requires an Eclipse Java Development Environment for the Java transformation
C. No Third Party Java API's are supported in the Java transformation
D. The Java transformation icon in PowerCenter Designer resembles a coffee bean
The word FALSE is a valid Filter transformation condition?
A. True
B. False
