EMT Practice Test

1. Question Content...

---

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

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

Question3: 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? Choose 2 answers

Question4: Given the picture shown below:

Identify all of the true and correct statements listed below. Note: The red (or gray) arrow points at the line in question.
The line on the left hand side of the picture which connects PRODUCT TO PRODUCT_COST : Choose 2 answers

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

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

Question7: Given the picture shown below:

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

Question8: Which one of the following transformations may be unconnected In a valid mapping? (choose one)

Question9: Regarding the Sorter transformation and assuming that Powercenter is not utilizing Pushdown Optimization, select the statement which is correct and true:

Question10: Which of the following statements is correct on workflow events?

Question11: 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)

Question12: What is the first column of the bad file?

Question13: 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)

Question14: Two pipelines (A & B) are entering a Joiner transformation with each having a record size of 100 bytes.
Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?

Question15: 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)

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

Question17: The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator transformation?

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

Question19: Based upon the graphic below, which answer correctly discribes the outcome of this workflow's execution given the start method: (The workflow is valid)
* Workflows > Start Workflow

Question20: How does a single joiner transformation join data?

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

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

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

Question24: Which of the following is true about database connections?

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

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

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

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

Question29: Using the Properties view of a Session task from the Workflow Monitor, the reason for a session's failure can possibly be determined?

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

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

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

Question33: Which command line tool would you use to import a workflow into a repository?

Question34: When would a Lookup transformation be classified as active?

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

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

Question37: Which of the following is not a Transaction Control Variable?

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

Question39: 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. Choose 2 answers

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

Question41: If after running a session task, it has been determined that the incorrect mapping was run for that session task, which of the following actions could be attempted?