Interview questions

Informatica interview questions – page 10

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

  1. SCD Mappings are mostly used Unconnected Lookup Transformation. Unconnected Lookup used static Cache only.At this time how can you insert or update date in Target by using static cache?

  2. Identifying bottlenecks in various components of Informatica and resolving them.

  3. What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA

  4. What are mapping parameters and varibles in which situation we can use it

  5. What r the types of maping in Getting Started Wizard?

  6. How to get the first 100 rows from the flat file into the target?

  7. There are 3 depts in dept table and one with 100 people and 2nd with 5 and 3rd with some 30 and so. i want to diplay those deptno where more than 10 people exists

  8. What r the types of metadata that stores in repository?

  9. What r the basic needs to join two sources in a source qualifier?

  10. How can we store previous session logs

  11. How to load time dimension?

  12. What are the tasks that Loadmanger process will do?

  14. How many number of sessions that You can create in a batch?

  15. How can u complete unrcoverable sessions?

  16. What are the types of data that passes between informatica server and stored procedure?

  17. Can any one explain real time complain mappings or complex transformations in Informatica.Specially in Sales Domain.

  18. What is Data cleansing..?

  19. How many types of dimensions are available in Informatica?

  20. How to delete duplicate rows in flat files source is any option in informatica

  21. What is meant by EDW?

  22. What is difference between lookup cashe and unchashed lookup?

  23. After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can u map these three ports directly to target?

  24. What is difference between partioning of relatonal target and partitioning of file targets?

  25. What is the difference between Power Centre and Power Mart? What is the procedure for creating Independent Data Marts from Informatica 7.1?

  27. What is difference between maplet and reusable transformation?

  28. How can you create or import flat file definition in to the warehouse designer?

  29. What are the types of maping in Getting Started Wizard?

  30. Why sorter transformation is an active transformation?

  31. What r the circumstances that infromatica server results an unreciverable session?

  32. What r the tasks that Loadmanger process will do?

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