Interview questions

DB Administration interview questions – page 11

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

  1. How is datastage 4.0 functionally different from the enterprise edition now? what are the exact changes?

  2. How do i allow a dynamic selection of a column for a measure in a chart,without using Variable

  3. What are the environment variables in datastage?give some examples?

  4. What is the difference between drs and odbc stage

  5. What is difference between data stage and informatica

  6. What's the difference between Datastage Developers and Datastage Designers. What are the skill's required for this.

  7. What is meaning of file extender in data stage server jobs.can we run the data stage job from one job to another job that file data where it is stored and what is the file extender in ds jobs.

  8. What r XML files and how do you read data from XML files and what stage to be used?

  9. Explain the process of taking backup in DataStage?

  10. Explain the differences between Oracle8i/9i?

  11. Please list out the versions of datastage Parallel , server editions and in which year they are realised.

  12. What is ' insert for update ' in datastage

  14. How to generate IQD file from framework manager

  15. How to use rank&updatestratergy in datastage

  16. Tell me the environment in your last projects

  17. What are components of report studio?

  18. How to implement type2 slowly changing dimensions in data stage?explain with example?

  19. How can we generate the cubes in framework manager?

  20. Do you know about INTEGRITY/QUALITY stage?

  21. Dimension Modelling types along with their significance

  22. What is the exact difference betwwen Join,Merge and Lookup Stage?

  23. What are the advantages and disadvantages of reporting directly against the database? Do you always need to copy the data before reporting on it?(example, real-time & on-demand reporting is a requirement)

  24. How to remove duplicates in server job

  25. Suppose if there are million records did you use OCI? if not then what stage do you prefer?

  27. How can i create prompts in report net

  28. Is there any comparison available for Cognos Reportnet Vs Crystal reports?

  29. What are orabulk and bcp stages?

  30. What are the differences between the data stage 7.0 and 7.5in server jobs?

  31. If a DataStage job aborts after say 1000 records, how to continue the job from 1000th record after fixing the error?

  32. What happens if the job fails at night?

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