IBM PUNE INTERVIEW QUESTIONS

IBM PUNE INTERVIEW QUESTIONS

IBM PUNE

1. WHAT IS FACT TABLE? WHY WE CAN USE FACT TABLE?

2.SEMI ADDITIVE FACTS& ADDITIVE FACTS

3.WHAT IS STAR SCHEMA&SNOW FLAKE SCHEMA?

4.WHAT IS RAPIDIALLY CHANGING DIMENSION?

5 DIFF 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 VARIABLE IF I TAKE STAGE VARIABLE WITH DATA TYPE VARCHAR WHAT WOULD BE THE DEFAULT VALUE?

11. WHAT IS THE USES ODBC STAGES?

12. WHAT IS THE DIFFERENCE BETWEEN JOIN AND LOOK UP STAGES?

13. IS IT POSSIBLE TO PERFORM LEFT OUTER JOIN IN MERGE AND LOOK UP?

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 COLUMNS HOW TO IMPLEMENT?

17. IS IT POSSIBLE TO IMPLEMENT THE SCD USING LOOK UP 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 ENTERPRISE STAGE, WHAT ARE THE PARAMETERS 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 RECORDS IN ORACLE TABLE?

25. WHAT IS THE EXECUTION SEQUENCE OF SELECT, WHERE, ORDER BY  GROUP BY, HAVING, CLAUSE?

26. WHAT IS THE NORMALIZATION AND DE NORMALIZATION?

27. HOW TO RELEASE THE LOCK FOR A PARTICULAR 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 FACT LESS FACT TABLE FROM CURRENT PROJECT?

31. WHAT IS THE COLUMN EXPERT STAGE?

32. PROJECT FLOW ENVIRONMENT VARIABLE AND JOB PARAMETER?