Just Crack Interview

Data Warehouse Developer interview questions – page 6

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

Advertisement

  1. How to display nth highest record in a table for example?How to display 4th highest (salary) record from customer table?

  2. How do u decide whether u need to do aggregations atdatabase level or at Informatica level?

  3. What is difference b/w pravite procedures and public procedures?

  4. Can we write to_date(three arguments) ? Will it work ?Advance thanks

  5. What is a sub query?how will you calculate working days in a month using sub query?

  6. What is the difference between Delete and Truncate

  7. What do you enjoy most about working here?

  8. What is diff between connected and unconnected lookup?

  9. When do we Analyze the tables? How do we do it?

  10. What is the use of DESC in SQL?

  11. What are the issues related with correlated subqueries? ????

  12. How to fine tune the mappings?

  13. Advertisement

  14. How do you find the maximum value in a column in db2?

  15. Find out first highest salary?

  16. What are difference between version control and debugging tools?

  17. Would you like to easily automate your MS Access database through menu driven selections?

  18. Can we insert and update a target table without using update strategy transformation?How?

  19. What format should my database be saved in to allow different versions of Microsoft Access to open the database?

  20. What is execute scalar?

  21. Why we use db2 with cobol why we cant use any other languages? what the main reason?what is disaster recovery?

  22. How to get the third quarter of employee details from emp?

  23. Differences between UNIQUE and DISTINCT in select statements

  24. What is Replication Manager?

  25. What are active transformation / Passive transformations?

  26. Advertisement

  27. Have you had an experience where you realized that you had to be more positive and persuasive when selling you ideas to others? What did you learn from this experience?

  28. Can any one describe what is audit table briefly?how does it look likeand what are the columns in it?

  29. What is the use of CASCADE CONSTRAINTS?

  30. How do you manage your time in a project when the project has a tight deadline? Give an example to prove your point.

  31. Let?s say the table in the database is named as TBL_Register. The fields in this table include:1. User_Name,2. User_Telephone,3. Register_DateThe field Register_Date stores the current date and time of the registration.Write the SQL statement that inserts the data into the table.

  32. Do you think this company is ambitious and if so, why?

Advertisement
Advertisement