Informatica PR000041 Exam Questions Free Practice Test

Viewing page 2 out of 3 pages

Viewing questions 11-20 out of questions

Questions # 11:

Which combination of Transaction Control transformation and target type results in an invalid mapping? (choose one)

Options:

Dynamic MQ Series target

MS target

Relational target

XML target

Expert Solution

Questions # 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?

Options:

5 fields are in the index cache and 3 are in the data cache

3 fields are in the index cache and 2 fields are in the data cache

2 fields are in the index cache and 3 fields are in the data cache

2 fields are in the index and 5 fields are in the data cache

Expert Solution

Questions # 13:

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

Options:

Yes, by dragging the reusable object into your mapping and unchecklng the Reusable checkbox

Yes' by first clicking the Ctrl key and then dragging the reusable object into the mapping

Yes, by first selecting the reusable object and while dragging the object into your mapping, hold the Ctrl key down

Expert Solution

Questions # 14:

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

Options:

A UDF name can contain letters, numbers and underscores

Can be used in mappings and transformations however not in mapplets

Can be reused from a shared folder as shortcut

Can contain Java code snippets

Expert Solution

Questions # 15:

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

Options:

Expression, Router, Joiner

Update Strategy, Expression, Aggregator

Stored Procedure, Joiner, Router

Router, Update Strategy, Joiner

Expert Solution

Questions # 16:

Given the picture shown below:

Question # 16

How many columns would be selected from the database using PowerCenter's generated sql statement?

Options:

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

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

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

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

Expert Solution

Questions # 17:

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)

Options:

If InputValue = 2, the output will be routed to Group A only

If InputValue = 2, the output will be routed to both groups A and B

If InputValue = 2, the router will fail, since rows cannot be routed to multiple groups

Any positive number values other than 1 or 2 will be routed to the Default group

Expert Solution

Questions # 18:

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

Options:

infasetup

infacmd

pmcmd

pmrep

Expert Solution

Questions # 19:

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

Options:

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

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

If the lookup finds two records that match the search key, it will return two records

None of the above

Expert Solution

Questions # 20:

What is the first column of the bad file?

Options:

Reject reason

Column Indicator

Overflow Indicator

Row Indicator

Expert Solution

Viewing page 2 out of 3 pages

Viewing questions 11-20 out of questions

Pass the Informatica Informatica Certified Professional ICP Program PR000041 Questions and answers with CertsForce