Interview questions

Informatica interview questions – page 11

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

  1. What are Target Options on the Servers?

  2. What is the default source option for update stratgey transformation?

  3. How do we estimate the number of partitons that a mapping really requires? Is it dependent on the machine configuration?

  4. How to recover the standalone session?

  5. What r the different types of Type2 dimension maping?

  6. What r the active and passive transforamtions?

  7. We are using Update Strategy Transformation in mapping how can we know whether insert or update or reject or delete option has been selected during running of sessions in Informatica.

  8. What is the diff b/w STOP & ABORT in INFORMATICA sess level ?

  9. How do we do unit testing in informatica? How do we load data in informatica ?

  10. How can you recognise whether or not the newly added rows in the source are gets insert in the target?

  11. Differences between Normalizer and Normalizer transformation.

  12. What is the procedure or steps implementing versioning if you are already in version7.X. Any gotcha's or precautions..

  14. What is the procedure to write the query to list the highest salary of three employees?

  15. What is rank transformation?where can we use this transformation?

  16. How many ways you can update a relational source defintion and what are they?

  17. How can we eliminate duplicate rows from flat file?

  18. What are the join types in joiner transformation?

  19. How can U create or import flat file definition in to the warehouse designer?

  20. What is the use of incremental aggregation? Explain me in brief with an example.

  21. In a sequential Batch how can we stop single session?

  22. About Informatica Power center 7:1) I want to Know which mapping properties can be overridden on a Session Task level.2)Know what types of permissions are needed to run and schedule Work flows.

  23. How a two dimension array is initialize with pointer?

  24. What is Load Manager?

  25. In which condtions we can not use joiner transformation(Limitaions of joiner transformation)?

  27. How many ways you can update a relational source defintion and what r they?

  28. What are the types of lookup?

  29. Why we use partitioning the session in informatica?

  30. With out using Updatestretagy and sessons options, how we can do the update our target table?

  31. How the informatica server increases the session performance through partitioning the source?

  32. Differences between connected and unconnected lookup?

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