NiC IT Academy

Informatica Quiz – 2

By Mr.Chandra

Loading

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

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

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

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

5) Which of the following statements are valid for Active and Passive Transformations?

6) Which of the following statements regarding mapplets are correct and true?

7) Which of the following is not a Transaction Control Variable?

8) Which command line tool would you use to import a workflow into a repository?

9) OLAP stands for?

10) How does a single joiner transformation join data?

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

12) The constant DD_INSERT may be used in an expression within which transformation or transformations?

13) Referring to the Lookup transformation, which statement is correct and true?

14) Referring to the Sequence Generator transformation, which statement is correct and true?

15) What will happen when the Informatica Server encounters multiple matches for a Lookup transformation by default?

16) Which transformation is used numerous times in multiple mappings?

17) What is meant by Active transformation?

18) What is the order of SQL execution in Source Qualifier Transformation?

19) If we want to remove duplicate value from Flat file, distinct can be applied on?

20) Which task is used anywhere in the workflow to run the shell commands?

Login with your email & password

Sign up with your email & password

Signup/Registration Form