Interview questions

DB Administration interview questions – page 10

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

  1. What happens to output when hash file is connected to transformer ..What error it throws

  2. What is the difference between Datastage and Datastage TX?

  3. How can you do incremental load in datastage?

  4. How do you fix the error "OCI has fetched truncated data" in DataStage

  5. Wht is the difference beteen validated ok and compiled in datastage.

  6. How to find the number of rows in a sequential file?

  7. How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?

  8. What is the utility you use to schedule the jobs on a UNIX server other than using Ascential Director?

  9. What are the difficulties faced in using DataStage ? or what are the constraints in using DataStage ?

  10. What are Routines and where/how are they written and have you written any routines before?

  11. What is the OCI? and how to use the ETL Tools?

  12. How do you do Usage analysis in datastage ?

  14. How will you call external function or subroutine from datastage?

  15. It is possible to run parallel jobs in server jobs?

  16. Can we use shared container as lookup in datastage server jobs?

  17. How we use NLS function in Datastage?

  18. Types of vies in Datastage Director?

  19. How we can call the routine in datastage job?explain with steps?

  20. Is OLAP databases are called decision support system ? true/false?

  21. How can u implement slowly changed dimensions in datastage? explain?

  22. Purpose of using the key and difference between Surrogate keys and natural key

  23. How the hash file is doing lookup in serverjobs? How is it comparing the key values?

  24. What user varibale activity when it used how it used !where it is used with real example

  25. How can we improve the performance of DataStage?

  27. What are components of reportnet?

  28. What other ETL's you have worked with?

  29. How can we improve the performance of DataStage jobs?

  30. How do you populate source files?

  31. There are three different types of user-created stages available for PX. What are they? Which would you use? What are the disadvantage for using each type?

  32. What is the difference between routine and transform and function?

Companies that ask DB Administration questions

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