Interview questions

Informatica interview questions – page 7

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

  1. How can you delete duplicate rows with out using Dynamic Lookup? Tell me any other ways using lookup delete the duplicate rows?

  2. How to create primary key only on odd numbers?

  3. How to create the staging area in your database

  4. How to lookup the data on multiple tabels.

  5. What is meant by Junk Attribute in Informatica?

  6. What is the difference between stop and abort

  7. How can we use pmcmd command in a workflow or to run a session

  8. Performance tuning in Informatica?

  9. What is the difference between summary filter and detail filter

  10. In my source table 1000 rec's r there.I want to load 501 rec to 1000 rec into my Target table ?how can u do this ?

  11. What r the diffrence between joiner transformation and source qualifier transformation?

  12. In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

  14. What are the scheduling options to run a sesion?

  15. What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow monitor? . The system hangs when 'Online' server connect option. The Informatica is installed on a Personal laptop.

  16. Which tasks can be performed on port level(using one specific port)?

  17. What are the types of groups in Router transformation?

  18. What is IQD file?

  19. What is difference b/w Informatica 7.1 and Abinitio

  20. What is pushdown optimizations in pc 8.x with example?

  21. What is Micro Strategy? Why is it used for? Can any one explain in detail about it?

  22. What happens if you try to create a shortcut to a non-shared folder?

  23. How can you stop a batch?

  24. How to load the data from people soft hrm to people soft erm using informatica?

  25. How do you handle decimal places while importing a flatfile into informatica?

  27. Can Informatica be used as a Cleansing Tool? If Yes, give example of transformations that can implement a data cleansing routine.

  28. How can u recognise whether or not the newly added rows in the source r gets insert in the target ?

  29. Can we run a group of sessions without using workflow manager

  30. Which transformation should u need while using the cobol sources as source defintions?

  31. How the informatica server sorts the string values in Ranktransformation?

  32. Can you use the maping parameters or variables created in one maping into any other reusable transformation?

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