Interview questions

DB Administration interview questions – page 13

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

  1. What is difference between Merge stage and Join stage?

  2. What is the meaning of the following..1)If an input file has an excessive number of rows and can be split-up then use standard 2)logic to run jobs in parallel3)Tuning should occur on a job-by-job basis. Use the power of DBMS.

  3. Types of Parallel Processing?

  4. How do you pass the parameter to the job sequence if the job is running at night?

  5. How do we provide security in frame work manager for a query subject?

  6. How do you merge two files in DS?

  7. How to implement type2 slowly changing dimenstion in datastage? give me with example?

  8. What about System variables?

  9. How can you implement Complex Jobs in datastage

  10. Whats difference betweeen operational data stage (ODS) & data warehouse?

  11. How can we implement Slowly Changing Dimensions in DataStage?.

  12. Is it possible to move the data from oracle ware house to SAP Warehouse using with DATASTAGE Tool.

  14. How good are you with your PL/SQL?

  15. How do you eliminate duplicate rows?

  16. It is possible to call one job in another job in server jobs?

  17. What is difference between qurry studio and report studio?

  18. What are Sequencers?

  19. How many jobs have you created in your last project?

  20. What will you in a situation where somebody wants to send you a file and use that file as an input or reference and then run job.

  21. Where does unix script of datastage executes weather in clinet machine or in server.suppose if it excutes on server then it will execute ?

  22. What are the enhancements made in datastage 7.5 compare with 7.0

  23. Do u know about METASTAGE?

  24. What are constraints and derivation?

  25. What is version Control?

  27. What Happens if RCP is disable ?

  28. What is a project? Specify its various components?

  29. I want to process 3 files in sequentially one by one , how can i do that. while processing the files it should fetch files automatically .

  30. How do you track performance statistics and enhance it?

  31. How much would be the size of the database in DataStage ?

  32. What is view is it possible to create index on view on view & how ?

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