Easter Sale Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

PowerCenter Data Integration 9.x:Developer Specialist Question and Answers

PowerCenter Data Integration 9.x:Developer Specialist

Last Update May 17, 2024
Total Questions : 70

We are offering FREE PR000041 Informatica exam questions. All you do is to just go and sign up. Give your details, prepare PR000041 free exam questions and then go for complete pool of PowerCenter Data Integration 9.x:Developer Specialist test questions that will help you more.

PR000041 pdf

PR000041 PDF

$35  $99.99
 Add to Cart
PR000041 Engine

PR000041 Testing Engine

$42  $119.99
 Add to Cart
PR000041 PDF + Engine

PR000041 PDF + Testing Engine

$56  $159.99
 Add to Cart
Questions 1

When would a Lookup transformation be classified as active?

Options:

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

Discussion 0
Questions 2

An Update Strategy transformation has the Forward Rejected Rows attribute unchecked. Which statement is correct and true?

Options:

A.  

Records that are tagged for rejection are projected downstream to the next transformation so long as the ports are connected properly

B.  

Records that are tagged for rejection are dropped and not projected downstream to the next transformation

C.  

The Forward Rejected Rows attribute cannot be cleared after the transformation is created

D.  

The Forward Rejected Rows attribute is only applicable when records are tagged for rejection upstream of the Update Strategy transformation

Discussion 0
Questions 3

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

Options:

A.  

Picosecond

B.  

Microsecor|d

C.  

Nanosecond

D.  

Millisecond

Discussion 0
Questions 4

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

Options:

A.  

1

B.  

2

C.  

3

D.  

4

Discussion 0
Questions 5

Which statement is correct regarding User-Defined Functions (UDF)?

Options:

A.  

A UDF name can contain letters, numbers and underscores

B.  

Can be used in mappings and transformations however not in mapplets

C.  

Can be reused from a shared folder as shortcut

D.  

Can contain Java code snippets

Discussion 0
Questions 6

Referring to the Java transformation: select the statement below which is correct and true.

Options:

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

Discussion 0
Questions 7

Referring to the SQL Transformation: which statements is correct and true.

Options:

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 (!)

Discussion 0
Questions 8

Transformation: Referring to Active and Passive characteristics - Select the statement which is correct and true.

Options:

A.  

If a transformation's Active property is cleared or not enabled, the transformation becomes passive

B.  

A transformation is active if it does not change the number of rows in the pipeline

C.  

Transformations can be active and passive at the same time

D.  

A passive transformation will not change the number of rows in the pipeline

Discussion 0
Questions 9

Which of following statements is valid for Dynamic lookups?

Options:

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

Discussion 0
Questions 10

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.

Options:

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

Discussion 0
PR000041 Questions Answers | PR000041 Test Prep | PowerCenter Data Integration 9.x:Developer Specialist Questions PDF | PR000041 Online Exam | PR000041 Practice Test | PR000041 PDF | PR000041 Test Questions | PR000041 Study Material | PR000041 Exam Preparation | PR000041 Valid Dumps | PR000041 Real Questions | Informatica Certified Professional ICP Program PR000041 Exam Questions