Interview questions

DB Administration interview questions – page 14

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

  1. Dimensional modelling is again sub divided into 2 types.

  2. What are necessary tasks to install reportnet software

  3. What are validations you perform after creating jobs in designer.What r the different type of errors u faced during loading and how u solve them

  4. Report Studio allows you to create the data model from a query and thereby skipping Framework Manager. Given that this feature is available, in what scenarios would one want to skip Framework Manager? Is Framework Manager an un-needed overhead?

  5. What is DS Designer used for - did u use it?

  6. What are types of Hashed File?

  7. I want to display zero when null values coming to report how can I do that?

  8. Wht is the extension of file to save template? What is the difference between drill through and masterdetail reports?

  9. What are Stage Variables, Derivations and Constants?

  10. What is difference between serverjobs & paraller jobs

  11. What is DS Manager used for - did u use it?

  12. What is merge and how it can be done plz explain with simple example taking 2 tables ...

  14. What function should you use to display the value entered or selected by a user in response to a prompt?

  15. How can we implement Lookup in DataStage Server jobs?

  16. What are the Repository Tables in DataStage and What are they?

  17. How can i test report in reportnet

  18. How can we join one Oracle source and Sequential file?.

  19. Briefly describe the various client components?

  20. Will the data stage consider the second constraint in the transformer once the first condition is satisfied ( if the link odering is given)

  21. How do you pass filename as the parameter for a job?

  22. What is data set? and what is file set?

  23. Difference between filter and conditin

  24. Defaults nodes for datastage parallel Edition

  25. What is row changing how u eliminate ?

  27. What is DS Administrator used for - did u use it?

  28. What is the flow of loading data into fact & dimensional tables?

  29. What is the use of tabular model,tabular SQL,tabular reference in real time application?

  30. Why Denormalization is promoted in Universe Designing?

  31. What is Modulus and Splitting in Dynamic Hashed File?

  32. Did you work in UNIX environment?

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