Question 1

When the Transformation Scope is set to All Input, which group of transformations listed below will always cause an upstream Transaction Control transformation to become ineffective? (choose one)
A) Filter, Joiner, Rank
B) Union, Filter, Aggregator
C) Rank, Lookup, Aggregator
D) Joiner, Rank, Sorter

Accepted Answer

The answer of When the Transformation Scope is set to...

Question 2

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

Accepted Answer

In a static, non-multi-row lookup, if a lookup search does not find a value, the original row is typically retained with nulls for the lookup fields, and if multiple matches are found, it usually results in an error or undefined behavior, not returning multiple records.

Question 3

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

Accepted Answer

A single joiner transformation can join data from 2 pipeline inputs.

Question 4

Given the picture shown below:  How many columns would be selected from the database using PowerCenter's generated sql statement?
A) 2 - Due to the line on the left hand side of the picture
B) 13 - Based on all of the links entering the Source Qualifier
C) 3 - Based on the all of the links between the Source Qualifier and the next transformation
D) Unknown - We need to know how many columns the target has

Accepted Answer

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

Question 5

Assuming that the value of Fl is 12 as it enters the decode statement, which of the following decode statements will produce the value V? 
A) Option A
B) Option B
C) Option C
D) Option D

Accepted Answer

The answer of Assuming that the value of Fl is...

Question 6

Given this picture of a PowerCenter Mapping and assuming there is no SQL override in the Source Qualifier:  Identify all of the true and correct statements listed below. 
A) This picture depicts a join that will be processed within the Informatica PowerCenter engine
B) This picture depicts a join that will be processed in a database
C) This picture depicts a SQL UNION operation
D) This picture depicts an Informatica Homogeneous Join

Accepted Answer

The answer of Given this picture of a PowerCenter Mapping...

Question 7

Which of the following PowerCenter applications is browser-based in the Informatica 9.x environment?
A) Repository Manager
B) Informatica Administrator
C) Workflow Monitor
D) Workflow Manager

Accepted Answer

The answer of Which of the following PowerCenter applications is...

Question 8

The constant DD_INSERT may be used in an expression within which transformation or transformations? (choose one)
A) Expression and Update Strategy
B) Update Strategy
C) Update Strategy and Lookup
D) Expression, Aggregator, and Update Strategy

Accepted Answer

The constant DD_INSERT is specifically used within the Update Strategy transformation to define insert operations.

Question 9

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

Accepted Answer

If InputValue = 2, it satisfies both Group A (InputValue = 2) and Group B (InputValue > 1), so the output will be routed to both groups A and B.

Question 10

In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)
A) Character day of week, character day of month, and character day of year respectively
B) Day of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively
C) Each produces numerical day of week
D) Numerical day of week, day of month, and day of year respectively

Accepted Answer

The format strings D, DD, and DDD in the TO_CHAR(date) function produce the numerical day of the week, day of the month, and day of the year, respectively.

Question 11

Subqueries can be used in the SQL override for uncached lookup transformations.

Accepted Answer

The answer of Subqueries can be used in the SQL...

Question 12

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

Accepted Answer

The index cache contains the fields that are part of the join condition, which are 2 in this case. The data cache contains all the fields that are connected downstream to the next transformation, which are 5 in this case.

Question 13

The Informatics Date/Time datatype supports values up to which level? (choose one)
A) Picosecond
B) Microsecor|d
C) Nanosecond
D) Millisecond

Accepted Answer

The Informatics Date/Time datatype supports values up to the nanosecond level.

Question 14

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

Accepted Answer

The data from the master pipeline is used to build the cache files in the Joiner transformation process. The master pipeline's data is cached because it is typically smaller, allowing for efficient joining with the detail pipeline's data.

Question 15

Referring to a lookup transformation: Which of the following statements are true and correct?
A) The caching of a flat file is optional if the data in the flat file is sorted
B) The lookup index cache file contains a searchable index of the records based on the lookup condition
C) When lookup caching is unchecked, PowerCenter will read from a locally stored cache file
D) The data cache contains all of the fields in the lookup transformation

Accepted Answer

The lookup index cache file contains a searchable index of the records based on the lookup condition, which is true.

Question 16

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) 2
C) 3
D) 4

Accepted Answer

The answer of A workflow has a session task. Both...

Question 17

Which attributes of a reusable Expression transformation can be edited within the Mapping Designer workspace?
A) The transformation's name, one of its port's default values, the tracing level or a Metadata Extension
B) The transformation's name or the tracing level
C) The transformation's name, one of its port's default values or the tracing level
D) The transformation's name is the only attribute that can be changed

Accepted Answer

The answer of Which attributes of a reusable Expression transformation...

Question 18

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

Accepted Answer

The OS process that is running after the service manager is started is called pmserver

Question 19

Of the statements below, which best describes the underlying process taken when a user connects to a PowerCenter Repository Service for the first time? For the puposes of this question, the PowerCenter Developer is the only PowerCenter client application running, there are 2 nodes in the domain, node 1 is a gateway node and node 2 is a worker node. The PowerCenter Repository Service is running on the worker node.
A) The user connects directly and immediately to the Repository Service
B) The user connects to the service manager of the gateway node, and after authentication and authorization, is re- Assigned to the Repository Service
C) The user connects to the service manager of the worker node that is running the Repository Service, is then authenticated, authorized, and connected to the PowerCenter Repository Service
D) The user first connects to the PowerCenter Integration Service and then after authentication and authorization, is connected to the PowerCenter Repository Service

Accepted Answer

The user initially connects to the service manager on the gateway node for authentication and authorization. Once authenticated, the connection is redirected to the Repository Service running on the worker node.

Question 20

Which of the following is a reusable task available in workflow manager?
A) Decision
B) Assignment
C) Control
D) Command

Accepted Answer

The answer of Which of the following is a reusable...

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

When the Transformation Scope is set to All Input, which group of transformations listed below will always cause an upstream Transaction Control transformation to become ineffective? (choose one)

Please choose one of the following. In a static, non-multi-row lookup,

How does a single joiner transformation join data?

Given the picture shown below: How many columns would be selected from the database using PowerCenter's generated sql statement?

Assuming that the value of Fl is 12 as it enters the decode statement, which of the following decode statements will produce the value V?

Given this picture of a PowerCenter Mapping and assuming there is no SQL override in the Source Qualifier: Identify all of the true and correct statements listed below.

Which of the following PowerCenter applications is browser-based in the Informatica 9.x environment?

The constant DD_INSERT may be used in an expression within which transformation or transformations? (choose one)

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)

In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)

Subqueries can be used in the SQL override for uncached lookup transformations.

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?

The Informatics Date/Time datatype supports values up to which level? (choose one)

When using the Joiner transformation and assuming that you are not employing the Push Down Optimization feature, which statement is correct?

Referring to a lookup transformation: Which of the following statements are true and correct?

Which attributes of a reusable Expression transformation can be edited within the Mapping Designer workspace?

Referring to Informatica Domain Architecture, select the statement which is correct and true.

Which of the following is a reusable task available in workflow manager?