1 :-

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’)

2 :-

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

3 :-

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

4 :-

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

5 :-

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

6 :-

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

7 :-

20. What is Slowly Changing Dimension-Type2?

8 :-

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

9 :-

8.  Can you attach the session log file in an email?

10 :-

11. Can Aggregate functions be used in expression transformation?

11 :-

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

12 :-

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

13 :-

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

14 :-

19. When a session task fails and produces no session log, what should you check next?

15 :-

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

16 :-

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

17 :-

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

18 :-

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?

19 :-

26. 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?

20 :-

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