Just Crack Interview

Data Warehouse Developer interview questions

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

Advertisement

  1. Six bells commence tolling together and toll at intervals of 2, 4, 6, 8 10 and 12 seconds respectively. In 30 minutes, how many times do they toll together ?

    1. 4
    2. 10
    3. 15
    4. 16
    5. 18

  2. Can Full Backup be performed when the database is open ?

  3. 1.What about System variables? 2.How can we create Containers? 3.How can we improve the performance of DataStage? 4.what are the Job parameters? 5.what is the difference between routine and transform and function? 6.What are all the third party tools used

  4. What are the steps involved in Database Shutdown ?

  5. In my report contain Product name, Amount, Country, Sales person.I want to create one prompt: Sales Territory.( Ex: asia, US, UK, AUS), but territory column is not there in my model and source.if u select the Asia in prompt page-?ll Asian country results

  6. How i create datastage Engine stop start script.Actually my idea is as below.!#bin/bashdsadm - usersu - rootpassword (encript)DSHOMEBIN=/Ascential/DataStage/home/dsadm/Ascential/DataStage/DSEngine/binif check ps -ef | grep DataStage (client connection is

  7. What other ETLs you have worked with?

  8. What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

  9. How can u implement slowly changed dimensions in datastage? explain?2) can u join flat file and database in datastage?how?

  10. How can I connect my DB2 database on AS400 to DataStage? Do I need to use ODBC 1st to open the database connectivity and then use an adapter for just connecting between the two? Thanks alot of any replies.

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

  12. What are the limitations of pushdown optimization technique ?Advance thanks

  13. Advertisement

  14. Name at least six file extensions of Microsoft Access?

  15. What does the Log Reader agent in SQL Server 2005 replication do?

  16. What is normalization? explain 1st NF, 2nd NF, 3rd NF

  17. What is the difference between etl tool and olap tools

  18. What are the three possible functions of the plus (+) operator in SQL Server 2005, the base installed T-SQL?

  19. Is there more the two primary key in a single table?

  20. What are the disadvantages of Sequence Generator T/R?

  21. Tell me about a time when you had to be very careful in communicating delicate information. What was the possible risk involved and how did you go about it?

  22. What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation?1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

  23. What are the various methods of getting incremental records or delta records from the source systems?

  24. Is there anything I've mentioned that makes you think I'm not the best candidate for this job?

  25. Describe to me in detail a time when you took the initiative in a major project.

  26. Advertisement

  27. When was the last occasion that you had to use your negotiating skills to bring about a resolution that was in everyone?s best interest?

  28. Where do we use connected and un connected lookups

  29. Detail about how you can import a sharepoint list?

  30. Can we update a target table (without primarykey) by using update strategy transformation?

  31. The Concatenation Operator in TSL is?

  32. What is the grain level in DWH? If i have year to day. whatis the grain level of DWH from year to day.

Advertisement
Advertisement