Just Crack Interview

Data Warehouse Developer interview questions – page 3

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

Advertisement

  1. Source target--------- --------name no sal name no sal max_salr 10 1000 r 10 1000 3000y 20 3000 y 20 3000 3000

  2. WHAT IS UNIQUE IDENTIFIER DATA TYPE?

  3. When was the last occasion that you were given an assignment to develop your mediating skills, and what was the conclusion?

  4. How we can add header and footer to flat files?

  5. If a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

  6. Write sql query following tablecity gender nochennai male 40chennai female 35bangalore male 25bangalore female 25mumbai female 15i want the required outputcity male femalechennai 40 35bangalore 25 25mumbai 15

  7. What is Views in sql server?

  8. What is unique key?

  9. Can you save your connection settings to a conf file?

  10. I am using the Switchboard Manager in MS Access. I am getting an error message "There was an error executing this command."

  11. I have a table(product),It contain fields(productname,cost).I want to retrieve the product name ,which cost is second maximum in the table?

  12. How many rows will return from dual table?

  13. Advertisement

  14. I have a table with fields(id,name,accnt_type)and in accounttype are FD,SAVING,RD. Write a query to get How many numberof People are in each type of Account?

  15. How to store date to database

  16. What is the difference between ExecuteUpdate and ExecuteQuery?

  17. What are some good ideas regarding user security in MySQL?

  18. If a clash of personalities were to occur with a colleague, what steps would you take to make the working relationship run smoothly?

  19. How do you start and stop MySQL on Windows?

  20. What is the use of temporary files?

  21. What is your first reaction when your senior manager assigns a task that you think is impossible?

  22. How do you optimize stored procedures ?

  23. Can anyone tell me the new features in Informatica 9 Version?

  24. How to find the 5th highest salary form each departmentusing 1.SQL Query 2. Informatica power center designer?

  25. What is a join and their types?

  26. Advertisement

  27. How can increase the performance of MySQL select query?

  28. Explain SQL Injection and how can you prevent them?

  29. How will you debug your procedure? If your procedure isaround 2000 lines and the expected output is 10 and we getonly output 5.So how will you debug it?Somebody pls give the correct answer?

  30. How do you start MySQL on Linux?

  31. What happens if we dont select data driven option?

  32. How do you handle stressful situations?

Advertisement
Advertisement