DELLOIT INTERVIEW QUESTIONS

DELLOIT  INTERVIEW QUESTIONS 

1.TELL ME ABOUT ONE COMPLEX JOB WHICH YOU DEVELOPED?HOW MANY JOBS YOU CREATED IN YOUR PROJECT?

2.WHAT IS THE DIFFERENCE B/W SURRO GATE KEY AND PRIMAY KEY?

3.HOW MANY COLUMNS WE CAN DO AGGREGATION OPERATION IN AGGREGATE STAGE?

4.HOW CAN WE SEE THE CONTENTS OF THE SEQUENTIAL FILE DATA?

5.TELL ME ABOUT SEQUENTIAL FILTER?

6.IS IT POSIBLE TO REJECT THE RECORD WHICH RECORD CONTAIN ‘HEAD’?

7.HOW CAN WE DO NULL TO VALUE IN SEQUENTIAL FILE?

8.TELL ME COMMAND LINE TO RUN THE JOB?

9.TELL ME COMMAND TO PASS PARAMETER?

10.HOW I CAN CALL SHELL PROGRAM IN JOB ?'

11.HAVE U USED ANY SCRIPT?WHERE?HOW?

12.I RUN 3 JOBS IN JOBS SEQUENCE 2ND JOB HAS BEEN ABORTED HOW CAN WE DO ?HOW CAN U RUN 2ND JOB?

13. HOW CAN WE DECLARE GLOBAL PARAMETER?