Informatica PR000041 ICP Exam Practice Test Instant Access

Question 1

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

AThe caching of a flat file is optional if the data in the flat file is sorted

BThe lookup index cache file contains a searchable index of the records based on the lookup condition

CWhen lookup caching is unchecked, PowerCenter will read from a locally stored cache file

DThe data cache contains all of the fields in the lookup transformation

Answer : B

Question 2

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

AThe data from the detail pipeline Is used to build the cache files used In the join process

BThe data from the master pipeline is used to build the cache files used in the join process

CThe cache files are built according to a sql override found on the Joiner Properties tab

DThe Joiner transformation uses the database to build the join result

Answer : B

Question 3

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

AThe Integration Service starts a JVM that executes the byte code to process data

BPowerCenter requires an Eclipse Java Development Environment for the Java transformation

CNo Third Party Java API's are supported in the Java transformation

DThe Java transformation icon in PowerCenter Designer resembles a coffee bean

Answer : A

Question 4

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

A2 -Due to the line on the left hand side of the picture

B13 -Based on all of the links entering the Source Qualifier

C3 -Based on the all of the links between the Source Qualifier and the next transformation

DUnknown - We need to know how many columns the target has

Answer : C

Question 5

What does the function SETVARIABLE ($$Variable, value) do?

AAssign the minimum value of the twoto $$Variable

BAssign the maximum value of the two to $$Variable

CAllows the assignment of a value to a parameter

DAssign the value to $$Variable, unless the value is null

Answer : D

Please Wait...

Informatica PR000041 PowerCenter Data Integration 9.x:Developer Specialist ICP Exam Practice Test

Question 1

Question 2

Question 3

Question 4

Question 5

Please Wait...

Popular Vendors

Informatica PR000041 PowerCenter Data Integration 9.x:Developer Specialist ICP Exam Practice Test

Question 1

Question 2

Question 3

Question 4

Question 5