Question 1

When would a Lookup transformation be classified as active?
A) When the setting for lookup policy on multiple match is Use Any Value
B) A lookup cannot be an active transformation
C) When the lookup is configured to return multiple rows
D) A lookup is always active

Accepted Answer

A Lookup transformation is classified as active when it is configured to return multiple rows, as this can change the number of rows passing through the transformation.

Question 2

What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression? functionname{1, COMPANY, 'i' , 'I')
A) CHOOSE
B) REPLACECHR
C) REG_REPLACE
D) INSTR

Accepted Answer

The REPLACECHR function is used to replace characters in a string, which fits the requirement to exchange 'i' with 'I'.

Question 3

Which is the correct priority of assigning a mapping variable?
A) Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value
B) Session parameter file, workflow parameter file, repository value, declared initial value
C) Repository value, workflow parameter file, pre-session assignment, session parameter file, default value
D) Repository value, declared initial value, default value

Accepted Answer

The correct priority for assigning a mapping variable is: Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value. This order ensures that the most specific and recent values are used first.

Question 4

Given a Union transformation with 2 input groups, which statement is correct and true?
A) Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.
B) Either input group can have a port that does not match the other input group. The precision, datatype, and scale does not have to be identical across both input groups.
C) When merging the 2 groups of data together, the Union transformation will remove duplicate rows.
D) The port names in each input group can be named the same.

Accepted Answer

In a Union transformation, both input groups must have matching ports with identical precision, datatype, and scale to ensure proper data merging.

Question 5

Which statement on workflows is correct?
A) In a default configuration, a workflow must contain at least one session task
B) A workflow can contain multiple start points
C) In a default configuration, a workflow parameter file overrides all parameter files in underlying sessions
D) Another workflow cannot be executed from within a workflow

Accepted Answer

The answer of Which statement on workflows is correct?
A) In...

Question 6

Referring to an Unconnected Lookup transformation: Which one of the following is true? (choose one)
A) An unconnected lookup can return multiple rows while a connected lookup may return only one
B) Both connected and unconnected lookups can return multiple rows
C) An unconnected lookup may return only one value while a connected lookup may return multiple rows
D) Both connected and unconnected lookups can return only one row

Accepted Answer

An unconnected lookup is designed to return only one value, whereas a connected lookup can return multiple rows.

Question 7

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

Accepted Answer

The answer of Which one of the following transformations may...

Question 8

Which command line tool would you use to execute a workflow?
A) infasetup
B) infacmd
C) pmcmd
D) pmrep

Accepted Answer

The "pmcmd" command line tool is used to execute workflows in Informatica.

Question 9

A user needs to compare mappings across two folders using the comparsion tool in PowerCenter Designer. What does the user account need in order to successfully complete the comparsion action? (Given that the user account has been granted the ability to use PowerCenter Designer)
A) Read permissions on the two folders
B) Read permissions on the two folders as well as have both folders opened
C) Full access (Read, Write and Execute permissions) on both folders
D) Mappings cannot be compared across folders using PowerCenter Designer

Accepted Answer

The user needs read permissions on both folders and must have both folders opened in PowerCenter Designer to compare mappings across them.

Question 10

Which of the following statements is correct on workflow events?
A) 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
B) A user-defined event can be created a-d raised in one workflow and then used In another
C) 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.
D) A user-defined event can be created in either the Event Wait or Event Raise task

Accepted Answer

The answer of Which of the following statements is correct...

Question 11

In which of the following selections are all of the transformations active?
A) Expression, Router, Joiner
B) Update Strategy, Expression, Aggregator
C) Stored Procedure, Joiner, Router
D) Router, Update Strategy, Joiner

Accepted Answer

All the transformations in option D (Router, Update Strategy, Joiner) are active transformations. Active transformations can change the number of rows that pass through them.

Question 12

Two pipelines (A & 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

Accepted Answer

The master pipeline in a Joiner transformation should be the one with fewer records to optimize performance and reduce memory usage. Therefore, Pipeline A with 1000 records should be the master.

Question 13

Which of these statements is correct concerning a Lookup transformation's persistent cache?
A) A persistent cache is stored on disk, and must be named to make it useable in multiple mappings
B) persistent cache is stored on disk, to refresh the cache the disk files must be deleted manually
C) When the Integration Service cannot find the persistent cache file and the recache property is not set, the session fails
D) A persistent cache can only be used by one mapping

Accepted Answer

A persistent cache is stored on disk and must be named to be used across multiple mappings, allowing for reuse and efficiency.

Question 14

What is a pipeline lookup transformation?
A) A lookup created using a pipeline which contains a target
B) A lookup cache split over pipelines of a partitioned mapping
C) A lookup associated with the Source Qualifier or an Application source such as JMS or SAP
D) A pipeline lookup does not exist

Accepted Answer

The answer of What is a pipeline lookup transformation?
A) A...

Question 15

In the Expression transformation graphic below, what is the value of the PREVIOUS_STATE port for row 2, given that the value for the STATE port was 'CA' for row 1? 
A) STATE
B) 'CA'
C) NULL
D) Value of the PREVI0US_STATE port is based upon its declared default value

Accepted Answer

The answer of In the Expression transformation graphic below, what...

Question 16

Which of the following Is NOT true of Aggregate functions?
A) You can place an aggregate function in a variable port
B) You can add a filter condition to calculate values for specific rows In the selected ports
C) You can use operators to perform arithmetic within the function
D) You can calculate a single value for all rows in a group

Accepted Answer

Aggregate functions cannot be placed in a variable port; they are typically used in output ports to calculate values based on groups of data.

Question 17

Using the Properties view of a Session task from the Workflow Monitor, the reason for a session's failure can possibly be determined?

Accepted Answer

The Properties view in the Workflow Monitor can provide details about the session's execution, including error messages and logs that can help determine the reason for a session's failure.

Question 18

The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator transformation?
A) Pass-through
B) Hash auto-keys
C) Not a valid partition points
D) Based on the transformation scope

Accepted Answer

The default partition type for an aggregator transformation receiving sorted input is "Hash auto-keys," which automatically uses the group by ports as partition keys.

Question 19

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 : 
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

Accepted Answer

The answer of Given the picture shown below:  Identify...

Question 20

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

Accepted Answer

Dynamic caching cannot be enabled on a lookup that returns multiple rows per search because it requires a unique key to update the cache efficiently.

Exam 3: PowerCenter Data Integration 9.x:Developer Specialist

When would a Lookup transformation be classified as active?

What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression? functionname{1, COMPANY, 'i' , 'I')

Which is the correct priority of assigning a mapping variable?

Given a Union transformation with 2 input groups, which statement is correct and true?

Which statement on workflows is correct?

Referring to an Unconnected Lookup transformation: Which one of the following is true? (choose one)

Which one of the following transformations may be unconnected In a valid mapping? (choose one)

Which command line tool would you use to execute a workflow?

A user needs to compare mappings across two folders using the comparsion tool in PowerCenter Designer. What does the user account need in order to successfully complete the comparsion action? (Given that the user account has been granted the ability to use PowerCenter Designer)

Which of the following statements is correct on workflow events?

In which of the following selections are all of the transformations active?

Two pipelines (A & 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?

Which of these statements is correct concerning a Lookup transformation's persistent cache?

What is a pipeline lookup transformation?

In the Expression transformation graphic below, what is the value of the PREVIOUS_STATE port for row 2, given that the value for the STATE port was 'CA' for row 1?

Which of the following Is NOT true of Aggregate functions?

Using the Properties view of a Session task from the Workflow Monitor, the reason for a session's failure can possibly be determined?

The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator transformation?

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 :

Which of following statements is valid for Dynamic lookups?