1. What are the types of lookup cache and explain them 2. What are the types of look up? 3. When do you use connected lookup and unconnected lookup 4. List the transformations you have used 5. In your project, in which scenario you have used Java transformation (I had used for splitting a comma separated value) 6. How to convert 1 row to 3 rows 7.How to fetch distinct records using Informatica PC 8. Explain connected and unconnected stored procedure transformation in informatica 9. How to read history log files/ read log files for previously run sessions 10. Difference between router and filter 11. Scenario: I get files for each region. The regions are not known in prior. How to load data from each regional source file to a separate file i.e. one file for each region using a single mapping. (Dynamically create target file for each region) 12. Have you used Data driven property in sessions? If yes, why did you use it? 13. In how many levels sorter handles NULL values? 14. Scenario: I have a file. I want to load only 1st, 3rd, 9th and the last record into target. How do you achieve this? 15. What is the unix command to find a file in the filesystem? 16. What is the difference between '>' and '>>' in unix? 17. How to handle aggregator transformation for better performance? 18. What is the difference between bulk load and normal load? 19. Why bulk load is faster than normal load? (Bulk load will not create indexes and check for constraints. The records bypass the data base management system and get loaded). What is the prerequisite for bulk load? 20. When do we use having clause in sql queries? 21. What is the difference between where clause and having clause? 22. If a query has where clause and having clause, which clause will get executed first, where or having? 23. Merge. I do not know if it is in Informatica or UNIX 24. How to improve performance of an sql query in oracle? 25. How will you find out which job is running using unix command? How will you move a process to background? 26. Since the mode of work has become 'work from home' now, how will you manage to work to balance your work life and professional life?
