Just Crack Interview

Data Warehouse Developer interview questions – page 5

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

Advertisement

  1. WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY.THAN U.

  2. What is the diff b/w local and global variable?

  3. What important goals have you achieved in the past year?

  4. My source is delimited flat file Flat file data is H|DateD1|ravi|bangalore D2|raju|pune T|4 The data will be send totarget if the fallowing two conditions satisfied 1.The firstrow Date column is equal to SYSDATE 2.Last record secondport equal to number of records. How to achieve?

  5. What is the difference between primary and unique key

  6. What happens if the both source and destination are named the same?

  7. Tow tables is there employee, projects .(many to many) one employee has different projects and oneproject has different employees . how we can achive the datafrom both

  8. How would you find out the total number of rows in a DB2 table?

  9. What are DTS subroutines? What is their use and How do you write them?

  10. How we can use more then one primary key in Single Table

  11. What is the query to find nth highest salary?What is the use of cursors?

  12. Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

  13. Advertisement

  14. How can we Get the Updated Rows? ie, There is 100s of Rows iupdated the Rows who have salary 5000. then i want to selectthe Updated Rows. How can we achieve it?

  15. What is diff joiner and lookup

  16. How we can count duplicate entery in particular table against Primary Key ? What are constraints?

  17. How do we extract SAP data Using Informatica? What is ABAP? What are IDOCS?

  18. What command is used to create a table by copying the structure of another table including constraints ?

  19. I declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

  20. What is ODS (operation data source)

  21. How do you import data from another access database?

  22. Explain about Microsoft access?

  23. Suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has afield dept id,dept name.Now I want to find out the emplyee list whose sal is between2000-3000 from dept x.

  24. What is joint?

  25. Difference between writing SQL query and stored procedure ?

  26. Advertisement

  27. What are the optimization techniques forQuery optimizationperformance issues andfaster execution of queries

  28. What is mean by prmary key and foreign key and how can we diffrentiate that?

  29. How we get second highest salary indatabase. Please show me this coding.

  30. Why do you want this position?

  31. Can you have multiple SPs with the same name on a database?

  32. I was asked in an interview..."Suppose u have a field with UNIQUE KEY. can u leave two or more cells NULL in SQL Server 2005...If Yes then Why...if NOT then Why.....

Advertisement
Advertisement