Just Crack Interview

Data Warehouse Developer interview questions – page 30

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

Advertisement

  1. What are the use of Roles ?

  2. What is SQL Loader? Explain the files used by SQL Loader to load file. i.e Loader control file, Input datafile, Log File, Bad File, Discard file

  3. What are the Characteristics of Data Files

  4. How do I convert Microsoft Works to Microsoft Word?

  5. How do I set the computer to use a single button on the Taskbar?

  6. What is a visual attribute?

  7. What are Smart Tags?

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

  9. What is SYSTEM tablespace and when is it Created?

  10. What is basic difference between SQL Server2000 and oracle?

  11. Shall we create procedures to fetch more than one record

  12. What is an UTL_FILE.What are different procedures and functions associated with it?

  13. Advertisement

  14. Defaults nodes for datastage parallel Edition

  15. Give the equivalent term in forms 4.0 for the following.Page, Page 0?

  16. Is it possible to attach same library to more than one form?

  17. List system variables available in forms 4.0, and not available in forms 3.0?

  18. What is the content view and stacked view?

  19. What is the difference between SID and Global Database Name ?

  20. What is hashing algorithm and explain breafly how it works?

  21. How can we pass parameters to job by using file.

  22. How I can convert Server Jobs into Parallel Jobs?

  23. Does Enterprise Edition only add the parallel processing for better performance?Are any stages/transformations available in the enterprise edition only?

  24. How do I turn on or off the Track Changes tool?

  25. What is the mean of Try to have the constraints in the 'Selection' criteria of the jobs itself. This will eliminate the unnecessary records even getting in before joins are made?

  26. Advertisement

  27. Any way to "zoom in" on a picture in slide show?

  28. How to change the default font in Word?

  29. What are the problems that arise with absolute addresses in terms of swapping?

  30. If data is partitioned in your job on key 1 and then you aggregate on key 2, what issues could arise?

  31. What are the differences you have seen while installing Oracle on NT and Unix platform

  32. What is the use of bitmap and char mode in system parameters in reports?

Advertisement
Advertisement