1. WHAT IS DIFFERENCE BETWEEN JOIN, LOOKUP, and MERGE?
2. WHEN WILL U GO THE LOOKUP, WHEN WILL U GO JOIN?
3.WHICH IS BEST PERFOMANCE, WHY?
4.WHERE WE CAN CALL SHELL SCRIPT IN DATASTAGE?
5.WHAT IS DIFF FACT TABLE AND DIMENSION TABLE,WHAT IS PURPUOSE OF BOTH CAN WE MAKE DATAWAREHJOUSE WITH OUT USING OF THOSE TWO.
6.DIFFERENCE BETWEEN UNION AND JOIN IN ORACLE?
7.DIFFERECE BETWEEN IN AND EXIST?
8.HOW CAN YOU SCHEDULE JOBS?
9. I WILL GIVE TWO DATES , HOW CAN U FINDOUT NO.OF DAYS BETWEEN THOSE TWO DATES?
10.TELL ME EXAMPLE PROCEDURE WHICH YOU IMPLEMENTD (WRITEN ) IN UR PROJECT.
11.WHY YOU HAVE TO USE FILES AS INTERMEDIATE STAGTE ? INSTED OF EXTRACTING DATA FROM DIRECTLY CLIENT OLTP SYSTEM?
12.PURPOSE OF STAGING AREA? WHAT ACTIVITIES YOU DON IN STAGING AREA?
13.EXACTLY TELL ME FUNCTIONALITY OF DATASTAGE TOOL?
14.HAVE YOU CONNECTED CLIENT SOURCE SYSTEM DIRECTLY ANY TIME?
15.HOW CAN WE ABORT THE JOB IF THE DATA IS DUPLICATE?
16.HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS "CHALAPATHI"?
17.TELL ME PROJECT ARCHITECHURE AND WHERE YOUR WORK STARTS?
18.WHICH UTILITY YOU USED IN YOUR PROJECT?
19.CAN WE DO HALF PROJECT IN SERVER JOBS AND HALF PROJECT ON PARLEL JOBS?
1.WRITE A MACRO IN TERADATA?
2.DIFF BETWEEN FASTLOAD AND BETAQ?
3.WHAT IS FACT TABLE AND WHAT IS DIMENSION TABLE?
4.DIFFERENCE BETWEEN SERVER JOBS AND PARLLEL JOBS?
5.HOW CAN WE FIND NO . OF SPACES IN PARTICULAR COLUMN?
6.DIFFERENCE BETWEEN SEQUENCE FILE AND DATASET?
7.DIFFERENCE BETWEEN BATCH JOBS AND JOB SEQUENCE JOBS?
8.DIFF B/W JOB CONTROL AND JOB SEQUENCE:
9.HAVE U INVOLVED PERFOMANCE TUNING ?WHICH TECHNIQUES DO YOU INVOLVED?
10.TELL ME WHAT IS CONFIGURATION FILE ?AND IN BOTH DISC SPACES CAN TAKE TEMPARORY MEMORY?
11.DIFFERENCE B/W SPARCE LOOKUP AND NORMAL LOOK UP?
12.TELL ME OPERATION IN DATASET FILE?HOW MANY TYPES OF DATASET
13.IS IT POSIBLE TO USE DATASET AS SOURCE FILE?
14.WHAT R THE READ MEATHODS IN SEQUENTIAL FILE.
15.WHAT IS THE COMBINALITY MODE?
1.WHAT IS UR SOURCE?
2.I HAVE SOURCE FILE WHICH CONTAINS DUPLICATE DATA,MY REQUIREMENT IS UNIQUE DATA SHOULD PASS TO ONE FILE AND DUPLICATE DATA SHOULD PASS ANOTHER FILE HOW?
3 MY REQUIREMENT IS ONE JOB HAS TO BE EXCUITE 9 TIMES
AND I HAVE TO RECEIVE A MAIL AFTER COMPLEATION OF 3 TIMES SUCCESS HOW CAN U DO ?
4.WHAT IS RCP IN REAL TIME WHICH EXACTLY YOU UD\SE IN UR PROJECT?
5.HAVE U WRITTEN ANY ROUTINE? WHER U HAVE WRITTEN?
6.TELL ME SITUATION WHEN WE HAVE TO TAKE HELP OF ROUTINE?
7 CAN WE INCREASE BUFFERSIZE OF PROCESSING STAGE?
WHERE WE CAN DO.
1.TYPES OF FILES?
2.CAN WE SEE THE DATA IN FIXED WIDTH FILE?
3.DIALY HOW MANY FILES YOU ARE RECEVING ?
4.WHAT INFORMATION CONTAINS IN THAT FILES?
5.HOW CAN CHANGE DATA TYPE OF FIXED WIDTH FILE?
6.HOW MANY FACT TABLES AND , HOW MANY DIMENSION TABLES IN
YOUR PROJECT, AND IN WHICH DIMENSION TABLES YOU IN VOLVING?
7.WHAT IS FUNCTIONALITY OF COPY STAGE?
8.I HAVE A SOURCE FILE WITH 4 COLOUMS CAN WE MAKE 2 COLOUMS TO ONE TARGERT AND ANOTHER 2 COLUMS TO ANOTHER TARGET BY USING COPY STAGE?
1.WHAT IS PRESITS FOR CREATING CONFIGURATION FILE?
2.WHAT IS PROCESSOR?
3.CONFIGURATRION FILE? PARTS OF FILE
4.SELF JOIN MEANS?AND EXPAND?
5.TELL ME TYPES OF ERRORS
6WHAT IS FORCE COMPILE?
7. TELL ME PIVOTE FUNCTIONALITY?
8.WHAT ARE THE JOB SEQUENCES STAGES?
9 NO OF CHARACTERS HOW CAN WE FIND OUT IN UNIX?
10.SAMPLE SHELL SCRIPT?
11.SEQUENCE USE IN ORACLE?
12.REMOVE DUPLICATES QUERY IN ORACLE?
13.WHAT IS PRIMARY KEY?
14.ORACLE STAGE CAPACITY HOW MUCH?
15.TYPE OF DATASETS?
16.HOW TO UNLOCK THE LOCKED FILE?
17.HOW TO KILL THE JOB IN UNIX?
18.HOW TO FIND PROCESS ID OF JOB?
19.DATE FORMAT IN DATASTAGE AND DATE FORMATION OF ORACLE?
20.HOW CAN WE CONVERT DATA FORMAT FROM DD/MM/YYYY TO YYYY/MM/DD IN DS?
21.HOW TO HANDLE EXCEPTION IN DS?
22. EXAMPLE OF FACTLESS FACT TABLE?
23.WHY WE HAVE TO USE FILES AS MEDIATERS BETWEEN SOURCESTSYEM AND STAGING AREA?
24.DIFF B/W DATASET AND SEQUENTIAL FILE?
25.TYPES OF FUNNEL STAGES IN DS?
26.WHAT IS PRE REQUISIT FOR 2 TABLES IF I WANT PERFORM UNION ALL OPERATION BETWEEN 2?
27.WHAT IS ALOVE MULTIPLE INSTANCE?
28.TYPES OF ERRORS AND TELL ME SOME EXAMPLES?
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?
1. WHAT IS FACT TABLE? WHY WE CAN USE FACT TABLE?
2.SEMI ADDTIVE FACTS& ADDTIVE FACTS
3.WHAT IS STAR SCHEMA&SNOW FLAKE SCHEMA?
4.WHAT IS RAPIDIALLY CHANGING DIMENSION?
5DIFF B/W OLTP& OLAP . WHY WE NEED TO GO FOR OLAP IN DW ?
6.HOW TO REMOVE DUPLICATE USING TRANSFORMS?
7.WHAT IS THE USE OF NORMALIZATION?
8.WHAT IS BRIDGE TABLE WHERE WE USE ?
9.WHAT IS CONFORMED DIMENSION AN CONFORMED FACTS?
10.WHAT IS THE STAGE VARABLE IF I TAKE STAGE VARIABLE WITH DATA TYPE VARCHAR WHAT WHOULD BE THE DEFAULT VALUE?
11. WHAT IS THE USES ODBC STAGES?
12. WHAT IS THE DIFFERENCE BETWEEN JOIN AND LOOKUP STAGES?
13. IS IT POSSIBLE TO PERFORM LEFT OUTER JOIN IN MERGE AND LOOKUP?
14. USING THE SORT STAGE HOW CAN YOU SEND THE UNIQUE RECORDS TO ONE TABLE AND DUPLICATE RECORDS IN TO ANOTHER TABLE?
15. FROM SOURCE DUPLICATES I NEED TO SEND FOURTH DUPPLICATE TO THE TARGET HOW CAN YOU IMPLEMENT?
16. HOW YOU IMPLEMENT THE SCD IF MY SOURCE TABLE CONSISTING CID, CNAME, ADDRESS, PHONE NUMBER BUT I NEED TO CAPTURE THE CHANGES, FOR FIRST THREE COULUMNS HOW TO IMPLEMENT?
17. IS IT POSSIBLE TO IMPLEMENT THE SCD USING LOOKUP STAGE?
18. DIFFERENCE BETWEEN SCD AND RCD?
19. WHAT IS THE COLUMN EXPORT STAGE?
20. WHAT IS THE CDC STAGE?
21. WHAT IS THE USE OF ORACLE ENTERPRICE STAGE, WHAT ARE THE PERAMETERS YOU HAVE TO SET?
22. WHAT IS THE VERSION CONTROLLING ?
23. HOW TO REMOVE THE DUPLICATE IN ORACLE TABLE?
24. HOW WE SEE ONLY DUPLICATE RECRORDS IN ORACLE TABLE?
25. WHAT IS THE EXECUTION SEQUENCE OF SELECT, WHERE, ORDERBY, GROUP BY, HAVING, CLAUSE?
26. WHAT IS THE NORMALIZATION AND DENORMALIZATION?
27. HOW TO RELESE THE LOCK FOR A PERTICULAR JOB UNLOCKED?
28. I HAVE THE SOURCE FROM UK, NORTH AMERICA HOW CAN I PASS THE DATA TWO TABLES BASED ON THE LOCATIONS?
29. DIFFERENCE BETWEEN 7.5 AND 8.0?
30. EXAMPLE FOR THE FACTLESS FACT TABLEFROM CURRENT PROJECT?
31. WHAT IS THE COLUMN EXPERT STAGE?
32. PROJECT FLOW ENVIRONMENT VARIABLE AND JOB PERAMETER?
1. DIFFERENCE BETWEEN PRIMARY KEY AND SURROGATE KEY
3. HOW CAN YOU GENERATE THE SEQUENCE IN ORACLE, WHAT IS PURPOUSE OF IT, WHAT IS THE SEQUENCE?
5. IS REMOVE DUPLICATE STAGE BELONGS TO PARALLEL PROCESSING EXECUTION OR SEQUENTIAL PROCESSING EXECUTION?
7. A PART FROM REMOVE DUPLICATE STAGE WHICH STAGES ARE SUPPORTS REMOVE DUPLICATE ACTIVITY HOW CAN WE IMPLEMENT IT?
8. HOW CAN WE DO LEFTOUTER JOIN IN LOOKUP?
9. LOOKUP ACTIVITY CAN WE DO IN ORACLE?
10. WHAT IS THE LEFTOUTER IN ORACLE?
12. HOW CAN WE SEE THE FILES IN A DIRECTORY(UNIX)?
14. WHAT IS THE PREREQUISITE FOR THE REFFERENCE LOOKUP?
16. WHAT IS KEY BASE PARTIONING? GIVE THE EXAMPLE?
18. DO YOU KNOW THE HASHING ALGORITHM HOW IT WORKES?
20. DIFFERENCE BETWEEN HASH TECHNIC AND DB2 PARTITIONING TECHNIC?
22. TELL ME QUERY FOR REMOVING DUPLICATES IN ORACLE?
24. HOW CAN YOU REMOVE THE DUPLICATES IN SORT AND TRANSFORMER?
26. ENTIRE PARTITIONING HOW IT WORKS?
28. TELL ME HOW TO IMPLEMENTATION OF SCD?
30. FUNCTIONALITY OF SURROGATE KEY?
32. AFTER USING OF FIRST SURROGATE KEY IN ONE TABLE, I WANT TO START THE STARTING NUMBER IS ENDING NUMBER OF FIRST SURROGATE KEY?
34. HOW CAN WE USE OF SURROGATE KEY IS IT FILE STAGE OR PROCESSING STAGE?
36. HOW DO U LOAD THE DATA IN TO TARGET?
38. WHAT IS THE FUNCTIONALITY OF RANGE LOOKUP IN 8.0?
40. WHAT IS DIFFERENCE BETWEEN ROW ID AND ROW NUMBER IN ORACLE?
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?
very very useful sir....
ReplyDeleteThank you