Invesco: Telephonic: 1. Explain me about ur self and ur current project details. 2. How much you can rate ur self in PLSQL 3. How much you rate ur self in SQL. 4. What database u have worked. 5. How will find duplicate records .tell me the query. 6. Suppose if you have a table like this Empid empname deptid sal Tell me the query, to get maximum salary of each department? 7. If in one table you have duplicate records. you have to keep one record in the table and delete all remaining duplicate records tell me the query. how will do? 8. Do you know joins in SQL? tell me all joins? 9. Do you have any idea on cursors ,procedures, triggers? 10. Do you know lookup types? 11. Tell me the differences between connected and unconnected lookup? 12. With out using update strategy transformation how will update a record in the target table? Explain with example? 13. What is joiner transformation? 14. Types of joins in Joiner transformation? 15. What is the difference between master and details outer join in joiner transformation? 16. What is sorter transformation? 17. Sorter transformation is active or passive? If active why? If Passive why? 18. What is source qualifier transformation? 19. source qualifier transformation is active or passive? If active why? If Passive why? 20. What is surrogate key? 21. What is sequence generator transformation? 22. What properties we are having in sequence generator? 23. What is reusable sequence generator transformation? 24. Suppose if am using reusable sequence generator transformation in mapping. and am having 10 records in my source. And am loading first 5 records in T1 and next 5 records in T2. Am connecting next value to id filed of two different targets like T1 and T2.Then what will be the generated values of id field in Target T1 and Target T2 for all records? 25. Suppose I have 10 source files, I have to load the all 10 files data into 1 target table by running the mapping 1s only. How will you do? 26. Suppose I have 1 file as source. I have to load this file data into 3 different targets which reside in different databases(like 1 table in SQL server,2 table in DB2,3 rd table netezza) How will you load? 27. DO you have any kind of knowledge on production support? What is process your following for production support jobs? 28. How will you schedule the jobs? Do you know autosys? 29. What is your part in Autosys ? Have you created any jill scripts in autosys? 30. Do you have any question for me?