Interview questions

Database Administrator (dba) interview questions – page 16

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

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

  2. What are the join types in joiner transformation?

  3. How would you print the output of an SQL statement from SPUFI? ?

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

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

  6. What is Load Manager?

  7. What are the types of lookup?

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

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

  10. Differences between connected and unconnected lookup?

  11. What is DTM process?

  12. While importing the relational source defintion from database, what are the meta data of source you import?

  14. What are the transformations that restricts the partitioning of sessions?

  15. What is the difference between informatics 7x and 8xand what is latest version?

  16. What is worklet and what use of worklet and in which situation we can use it

  17. How is the union transformation active transformation?

  18. What are two modes of data movement in Informatica Server?

  19. What is mystery dimention?

  20. What are cost based and rule based approaches and the difference

  21. What are the types of metadata that stores in repository?

  22. What is the relation between free list and buffer busy wait?

  23. In update strategy target table or flat file which gives more performance ? why?

  24. What are the basic needs to join two sources in a source qualifier?

  25. Know the rules associated with transferring and sharing objects between repositories

  27. If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

  28. How can I get distinct values while mapping in Informatica in insertion?

  29. What is Data Transformation Manager?

  30. What are the new features of the server manager in the informatica 5.0?

  31. Could anyone please tell me what are the steps required for type2 dimension/version data mapping. how can we implement it

  32. What is a clustered index?

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