Interview questions

Informatica interview questions – page 2

484 questions. Tap “Show answer” to check yourself.

  1. Can we send mail when ever it get success or faulure to other mailid?

  2. What is normalization? explain 1st NF, 2nd NF, 3rd NF

  3. What are the disadvantages of Sequence Generator T/R?

  4. What is curr val use for in sequence generator?

  5. What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation?1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

  6. We have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have torun how can you do in unix?

  7. How to improve the performance of Aggregate transformation?

  8. Difference between informatica 8.1.1 and 8.6? Anddifferent betweeninformatica 7x and 8x?

  9. Can u explain me banking domain projects ?

  10. Can we update a target table (without primarykey) by using update strategy transformation?

  11. What is the grain level in DWH? If i have year to day. whatis the grain level of DWH from year to day.

  12. Why the UNION TRANSFERMATION is an Active TRANSFERMATION

  14. How to write a procedure for a date which is in threedifferent formats,and you want to load into datawarehouse inany single date formate

  15. 2,if we have 3 pipeline containing 3 targets and each targetis connected with diff sequence generator ,let us assumefirst target is populated with seq no1-9,so what would bethe number generated by other two sequence generator?what isthe diff in o/p if when we use reusable sequencegenerator?what would be the diff if we place expression inbetween target and sequence generator?

  16. In update strategy t/r we had given dd_insert condition& in session we gave delete condition .Then what will happen? mapping will run ?

  17. How to do Integration testing in Informatica?

  18. Without matching columns in two tables. how can you join

  19. Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

  20. My session have to run Monday to Saturday not run sunday howto sedule in informatica level?

  21. What type of documents you receiving from client later wtcan you do? what type of documents have to prepare?

  22. How we can add header and footer to flat files?

  23. What is the method of seperating unique and duplicaterecords in session level?

  24. How to return multiple columes through through un-connectlookup?

  25. Can anyone tell me the new features in Informatica 9 Version?

  27. What happens if we dont select data driven option?

  28. Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

  29. On a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

  30. ,if we have single SQ in flow and we have router in which ithas two group and we want to join these two groups withjoiner ?is it possible?

  31. How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

  32. How many new transformations are introduced in 8.1 which arenot available in 7.1?any new transformation in 8.6?

Companies that ask Informatica questions

Bending Spoons Interview guide Spiralyze Interview guide Winman Software India Interview guide Namecheap Interview guide Softsquare Interview guide E-Con Systems Interview guide