Question 1

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

Accepted Answer

A)  Repository Manager 
B)  Informatica Administrator 
C)  Workflow Monitor 
D)  Workflow Manager 
A)  Repository Manager 
B)  Informatica Administrator 
C)  Workflow Monitor 
D)  Workflow Manager

Question 2

A Pipeline Normalizer transformation will reflect one input port for each occurs value which Is greater than 1.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

What is the first column of the bad file?

Accepted Answer

A)  Reject reason 
B)  Column Indicator 
C)  Overflow Indicator 
D)  Row Indicator 
A)  Reject reason 
B)  Column Indicator 
C)  Overflow Indicator 
D)  Row Indicator

Question 5

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

Accepted Answer

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

Question 6

Which of the following statments are valid for Active and Passive Transformations?

Accepted Answer

A)  A transformation is active if It rearranges the order of the rows in the pipeline 
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 
A)  A transformation is active if It rearranges the order of the rows in the pipeline 
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

Question 7

Can you use a Decode function to perform multiple searches based on a single search value?

Accepted Answer

A)  No 
B)  Yes 
C)  Yes, but only if the port being searched Is sorted first 
D)  Yes, but only if the port is downstream of a router transformation 
A)  No 
B)  Yes 
C)  Yes, but only if the port being searched Is sorted first 
D)  Yes, but only if the port is downstream of a router transformation

Question 8

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.

Accepted Answer

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

Question 9

From within your folder, is it possible to make a non-reusable copy of a reusable transformation for use in a mapping?

Accepted Answer

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

Question 10

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?

Accepted Answer

A)  Option A 
B)  Option B 
C)  Option C 
D)  Option D 
A)  Option A 
B)  Option B 
C)  Option C 
D)  Option D

Question 11

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

Accepted Answer

A) True 
 B)False

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?

Accepted Answer

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

Question 13

How does a single joiner transformation join data?

Accepted Answer

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

Question 14

When would a Lookup transformation be classified as active?

Accepted Answer

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

Question 15

Which of the following is not a Transaction Control Variable?

Accepted Answer

A)  TC_CONTINUE_TRANSCTION 
B)  TC_COMMIT_TRANSACTION 
C)  TC_ROLLBACK_BEFORE 
D)  TC COMMIT AFTER 
A)  TC_CONTINUE_TRANSCTION 
B)  TC_COMMIT_TRANSACTION 
C)  TC_ROLLBACK_BEFORE 
D)  TC COMMIT AFTER

Question 16

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)

Accepted Answer

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

Question 17

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)

Accepted Answer

A)  Filter, Joiner, Rank 
B)  Union, Filter, Aggregator 
C)  Rank, Lookup, Aggregator 
D)  Joiner, Rank, Sorter 
A)  Filter, Joiner, Rank 
B)  Union, Filter, Aggregator 
C)  Rank, Lookup, Aggregator 
D)  Joiner, Rank, Sorter

Question 18

Which of the following is true about database connections?

Accepted Answer

A)  Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS 
B)  PowerCenter connections may be created In either the Administrator or the Workflow Manager 
C)  MRS connections may be created in either the Workflow Manager or the Administrator 
D)  Connections may be created in the Administrator for the MRS and in the Workflow Manager for PowerCenter Repositories 
A)  Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS 
B)  PowerCenter connections may be created In either the Administrator or the Workflow Manager 
C)  MRS connections may be created in either the Workflow Manager or the Administrator 
D)  Connections may be created in the Administrator for the MRS and in the Workflow Manager for PowerCenter Repositories

Question 19

What is a pipeline lookup transformation?

Accepted Answer

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

Question 20

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

Accepted Answer

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

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

A Pipeline Normalizer transformation will reflect one input port for each occurs value which Is greater than 1.

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

What is the first column of the bad file?

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

Which of the following statments are valid for Active and Passive Transformations?

Can you use a Decode function to perform multiple searches based on a single search value?

From within your folder, is it possible to make a non-reusable copy of a reusable transformation for use in a mapping?

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?

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?

How does a single joiner transformation join data?

When would a Lookup transformation be classified as active?

Which of the following is not a Transaction Control Variable?

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)

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)

Which of the following is true about database connections?

What is a pipeline lookup transformation?

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

Data Quality 9.x Developer Specialist

PowerCenter Data Integration 9.x Administrator Specialist

Filters

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

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

A Pipeline Normalizer transformation will reflect one input port for each occurs value which Is greater than 1.

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

What is the first column of the bad file?

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

Which of the following statments are valid for Active and Passive Transformations?

Can you use a Decode function to perform multiple searches based on a single search value?

From within your folder, is it possible to make a non-reusable copy of a reusable transformation for use in a mapping?

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?

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?

How does a single joiner transformation join data?

When would a Lookup transformation be classified as active?

Which of the following is not a Transaction Control Variable?

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)

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)

Which of the following is true about database connections?

What is a pipeline lookup transformation?

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

Data Quality 9.x Developer Specialist

PowerCenter Data Integration 9.x Administrator Specialist

Filters