Interview questions

Database Administrator (dba) interview questions – page 15

1,040 questions. Tap “Show answer” to check yourself.

  1. 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

  2. How to load time dimension?

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

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

  5. How can u complete unrcoverable sessions?

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

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

  8. How to retrieve n-th row ie n-th record of any table irrespective of the columns and the values present in the table without using ROWID(As it is not supported in DB@)

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

  10. What is meant by EDW?

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

  12. 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?

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

  15. What is difference between maplet and reusable transformation?

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

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

  18. Why sorter transformation is an active transformation?

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

  20. What is maximum number of one storage group?

  21. What are Target Options on the Servers?

  22. What is meant by index cardinality?

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

  24. How to recover the standalone session?

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

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

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

  29. Differences between Normalizer and Normalizer transformation.

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

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

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

Companies that ask Database Administrator (dba) questions

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