• DATA?
• DB?
• DBMS?
• SQL?
• RDBMS?
• DDL?
• DML?
• TCL?
• DCL?
• DQL?
• DATA TYPES?
• SUB-QUERY?
• CORRELATED SUB-QUERY?
• INLNE VIEW?
• JOINS?
• DATE FUNCTIONS?
• CHAR FUNCTION?
• NUMBER FUNCTION?
• SEQUNCES?
• VIEWS?
• SYNONYMS?
• GROUP BY?
• HAVING?
• WHERE?
• IN/NOT IN?
• EXISTS/NOT EXISTS?
• SET OPERATORS?
• INDEXES?
• NORMALIZATION?
  • 1^ST NORMAL FORM
  • 2^ND NORMAL FORM
  • 3^RD NORMAL FORM
• RANKING FUNCTION?
  • RANK()
  • DENSE_RANK()
• AGGREGATE FUNCTIONS?
  • MAX()
  • MIN()
  • AVG()
  • SUM()
  • COUNT()

• ANALYTICAL FUNCTIONS?
  • ROLLUP()
  • CUBE()
  • GROUP_ID()
  • GROUPING_ID()
• CONSTRAINTS?
  • PRIMARY KEY?
  • FOREIGN KEY?
  • UNIQUE?
• MERGE STATEMENT? DATA WAREHOUSE CONCEPTS:
• OLTP?
• OLAP?
• OLTP VS OLAP?
• DWH ARCHITECTURE?
• ETL VS ELT ARCHITECTURE?
• DIMENSIONS?
• FACTS?
• DATA MART?
• SCHEMA CREATION?

ADMIN TASKS IN ODI:

• INSTALLATION OF ODI?
• INSTALLATION OF DB?
• CONFGURATION IN ODI?
• CREATING MASTER REPOSITORY?
• CREATING WORK REPOSITORY?
• DATA SERVER?
• PHYICAL ARCHITECTURE?
• LOGICAL ARCHITECTURE?
• CONTEXT?
• DATA MODEL?
• DATA STORE?
• MASK?
• E?
• TYPES OF E?
  • STANDARD
  • CUSTOMISED
• JDBC DRIVER?
• JDBC URL?
• JNDI?

• TYPES OF REPPOSITORY?
• TYPES OF WORK REPOSITORY?
• KNOWLEDGE MODULES?
• TYPES OF KNOWLEDGE MODULES?
  • IKM
  • LKM
  • CKM
  • RKM
  • SKM
  • JKM

DEVELOPER TASKS:

• INTERFACES?
  • TABLE TO FILE?
  • TABLE TO TABLE?
  • TABLE TO XML?
  • FILE TO FILE?
  • FILE TO TABLE?
  • FILE TO XML?
  • XML TO FILE?
  • XML TO TABLE?
  • XML TO XML?
• YELLOW INERFACES?
• FILTERS?
• JOINS?
  • INNER JOIN
    • EQUI JOIN
    • NON-EQUI JOIN
    • NATURAL JOIN
  • OUTER JOIN
    • LEFT OUTER JOIN
    • RIGHT OUTER JOIN
    • FULL OUTER JOIN
    • CROSS JOIN
  • LOOK UP'S?
  • DATA SETS?
    • UNION
    • UNION ALL
    • INTERSECT
    • MINUS
  • PROJECTS?
  • SEQUENCES?
  • VARIABLES?
    • PROJECT VARIABLES?

• GLOBAL VARIABLES?
  • VARIABLES IN TOPOLOGY?
  • VARIABLES IN FILTERS?
  • VRIABLES IN PACKAGES?
    • DECLARE VARIABLE
    • REFRESH VARIABLE
    • SET VARIABLE
    • EVALUATE VARIABLE
  • VARIABES IN JOINS?
  • VARIABLES IN PROCEDURES?
• PACKAGES?
• USER FUNCTIONS?
• MARKERS?
• PROCEDURES?
• SCENARIOS?
• LOAD PLANS?
• QUALITY CONTROL?
• STATIC CONTROL VS FLOW CONTROL?
• SCHEDULING?
• LOADING STRATEGY?
  • CONTROL APPEND
  • SCD1
  • SCD2
  • SCD3
• TYPES OF DIMENSIONS?
• TYPES OF FACTS?
• REFERENCE KEY?
• NATURAL KEY?
• SURROGATE KEY?
• OPERATOR?
• LOAD PLAN EXECUTIONS?
• LOAD PLAN AND SCENARIOS?
• LANGUAGES?
• REPOSITORIES?
• GENERIC ACTIONS?
• PROFILES?
• TYPES OF PROFILES?
  • GENERIC PROFILES
  • NG PROFILES
• USERS?
• OBJECTS?
• ROUTER TRANSFERTION?
• MULTI TABLE INSERT?
• ROLLBACK TRANSFERMATION?

• STAND ALONE AGENT CREATION?
• JAVA EE AGENT CREATION?
• WEBLOGIC SERVER INSTALLATION?
• UPGRADING FROM 11G TO 12C?
• DATA LINEAGE?
• STAR SCHEMA?
• SNOW FLAKE SCHEMA?
• START FLAKE SCHEMA?
• PARALLELA EXECUTION VS SEQUENTIAL EXECUTION?
• CDC
  • SIMPLE CDC?
  • COMPLEX CDC?
• SNP TABLES?

     Interview Discussion

• Resume Guidance
• Interview Tips

Mock Interview session