RELIANCE COMPANY INTERVIEW QUESTIONS

RELIANCE COMPANY INTERVIEW QUESTIONS

1. WRITE A QUERY TO DELETE THE RECORDS WHICH ARE RECENTLY LOADED IN THE TABLE?

2. WRITE A QUERY TO VIEW nth HIGHEST SALARY EMPLOYEE DETAILS?

3. HOW CAN WE PERFORM SECOND EXTRACTION OF CLIENT DATABASE, WITHOUGHT ACCEPTING DATA WHICH WE ARE ALLREADY EXTRACTED IN FIRST EXTRATION TIME?

4. WHAT IS METERIALSED VIEW IN OUR PROJECT EXACTLY WHERE WE CAN USE IT?

5. HOW CAN WE USE PERAMETERS IN ORACLE, IN DATASTAGE?

6. WRITE A ARCHITECTURE OF PROJECT?

7. WHAT ARE THE DAY TO DAY ACTIVITIES OF ETL DEVELOPER?

8. HOW TO IMPLEMENT CHANGING DIMENSION?

9. TYPES OF BLOCKS IN PLSQL?

10. WHAT ARE IN, OUT PERAMETER IN PLSQL?

11. WRITE A QUERY TO DISPLAY DIPARTMENT WISE HIGHEST SALARY EMPLOYEE IS SENIOUR NUMBER WISE WITH USER INTRACTION?

12. WHAT IS THE CAPACITY OF EXCELL FILE (HOW MAY RECORDS IT CAN HOLD)?

13. TELL ME KIND OF PERFORMANCE TUNNING WHICH YOU IMPLEMENTED?

14. DO YOU KNOW ANY OF REPORTING TOOL?

15. HAVE WORKED ON ANY OF MIGRATION PROJECT? WHAT IS MIGRATION?

16. WHY YOUR CLIENT DON’T GIVE THE PERMITION TO ACCESS DATA DIRECTLY? INSTEAD OF THAT WHY FILES ARE PROVIDING BY HIM?

17. WHAT IS THE LEFT OUTER JOIN, TELL ME HOW CAN WE IMPLEMENTED IN ORACLE?

18. WHAT IS THE FUNCTION IN ORACLE TO SEE THE NUMBER OF DAYS BY PASSING DATE?

19. WHAT IS THE EXTENSION OF YOUR SOURCE FILE?

20. CAN YOU DO THE MODELING PART?

21. IN STAGING AREA EVERY TIME WE NEED TO LOAD THE DATA AND EVERY TIME WE NEED TO DELETE EXACTLY TELL ME WHAT IS PURPOUSE OF STAGING AREA?

22. IN WHICH TOOLS DO YOU HAVE IDIA ABOUT A PART FROM DATASTAGE?

23. EVERY INPUT FILE CONTAIN ONE SINGLE TABLE RIGHT?

24. WHAT IS THE PURPOUSE OF AGGREGATOR STAGE? WE HAVE AGGREGATION PARTITION IN ORACLE WHICH IS BETTER?

25. HAVE YOU INVOLVED ANY ORACLE SCRIPTING PART?

26. WIRTE A SHELL PROGRAMM WHICH IS EXAMPLE IF PASSING EAVEN AND ODD NUMBERS?

27. WHAT ARE THE THIRD PARTY TOOL USED IN YOUR PROJECT? TELL ME PURPOUSE OF THOSE?