informatica training in ameerpet, informatica training in hyderabad, informatica online training

DATAWAREHOUSE BASICS                                                      

What is BI & Data warehouse& Data warehousing

·         Decision support systems

·         What is an OLTP

·         Characteristics of OLTP

·         OLTP vs. Data warehouse (OLAP)

·         Data mart

·         Data mart vs. Data warehouse

·         Different kinds of source systems

a)      Data ware housing approaches, Top-down, Bottom-up.

·         Staging area & its operations,Extraction,Transformation, Loading, Data cleansing, Data merging, Data sampling, Data Aggregation, Data Scrubbing.

DATA MODELLING                                                                                             

·         What is fact &dimension, Surrogate keys, Different kinds of facts, Additive,Semi-additive, Non additive, Fact less fact.

·        Different kinds of dimensions, Junk dimension, Confirmed dimension, Role playing dimension, Slowly changing dimension, Inferred Dimension, Star schema, Snow-flake-schema, Dimensional modelling process.

·         INFORMATICA 9.X                                                                     

  Introduction to Informatica &Power enter Components More details clickhere :