Interview questions

Informatica interview questions – page 15

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

  1. What is the diff b/w Stored Proc (DB level) & Stored proc trans (INFORMATICA level) ?again why should we use SP trans ?

  2. Can batches be copied/stopped from server manager?

  3. Where should you place the flat file to import the flat file defintion to the designer?

  4. How do you configure mapping in informatica

  5. What is the procedure to load the fact table.Give in detail?

  6. When do u use a unconnected lookup and connected lookup...what is the difference between dynamic and static lookup...y and when do v use these types of lookups ( ie...dynamic and static )

  7. I have windows xp. I was told a person could find out what sites a person is looking on your computer. How do you do this. I have a person who uses my computer, and I think he is looking at sites he should not be viewing.

  8. Know the rules associated with transferring and sharing objects between folders.

  9. What is update strategy transformation?

  10. Explain use of update strategy transformation

  11. What are the reusable transforamtions?

  12. What is a junk dimension

  14. What is the look up transformation?

  15. What are the tasks that source qualifier performs?

  16. Diff between static and dynamic cache? and please explain with one example?

  17. What r the unsupported repository objects for a mapplet?

  18. The differences between using native and ODBC server-side databaseConnections

  19. What are the data movement modes in informatcia?

  20. What are the settiings that you use to cofigure the joiner transformation?

  21. What is Datadriven?

  22. What is the difference between Informatica 7.0 and 8.0 ?

  23. Can any one comment onsignificance of oracle 9i in informatica when compared to oracle 8 or 8i.I mean how is oracle 9i advantageous when compared to oracle 8 or 8i when used in informatica

  24. Can U use the maping parameters or variables created in one maping into another maping?

  25. Define Informatica Repository?

  27. What is the Router transformation?

  28. What is a view? How it is related to data independence? And what are the different types of views,and what is Materialize view

  29. Where do we use MQ series source qualifier, application multi group source qualifier. just give an example for a better understanding

  30. What are variable ports and list two situations when they can be used?

  31. How do you create a mapping using multiple lookup transformation?

  32. What is polling?

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