1 :-

23. Which command line tool would you use to execute a workflow

2 :-

11. Can Aggregate functions be used in expression transformation?

3 :-

5. A Mapping variable which gets its value through the use of the mapping variable function, setcountvariable, must use which aggregation type?

4 :-

16. How is the number of Normalizer input ports determined?

5 :-

28. Which one of the following transformations may be unconnected in a valid mapping?

6 :-

20. What is Slowly Changing Dimension-Type2?

7 :-

15. A lookup transformation that returns multiple rows can have what type of cache?

8 :-

22. An Unconnected Stored Procedure can run in the following fashions? 

9 :-

6. When creating a mapping variable with the IsExprVar attribute is set to TRUE, what data type must be assigned to variable?

10 :-

24. Which of the following is a reusable task available in workflow manager?

11 :-

29. What is the first column of the bad file?

12 :-

7. Which of the operations below is supported by worklets? Check all that apply.

13 :-

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

14 :-

1. You must convert a string that stores two digit date from 20th century (ex:05/20/97) to a date/time value that contains a four digit format(ex:05/20/1997). Which format string below would return the desired value?

15 :-

12. Which transformations listed below support the use of variable ports?

16 :-

30. Which of the following is not a Transaction Control Variable?

17 :-

3. Which function would be used in the following expression to return Mocikingbird if the division port’s values is 25? ________ (Division,10,’Cardnail’,15,’Whippoorwill’,20,’piper’,25,’Mockingbird’)

18 :-

2. What is the correct syntax to extract the second and third character of a string?

19 :-

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

20 :-

Which of the following PowerCenter application is browser based in the Informatica environment?