Informatica Training in ameerpet, Informatica online Training in ameerpet, informatica online training, Informatica Training in hyderabad

Informatica training center in ameerpet, hyderabad

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,Data ware housing approaches

a)      Top-down

b)      Bottom-up,Staging area & its operations

a)      Extraction

b)      Transformation

c)      Loading

d)     Data cleansing

e)      Data merging

f)       Data sampling

g)      Data Aggregation

h)      Data Scrubbing

DATA MODELLING What is fact &dimension,Surrogate keys,Different kinds of facts

a)      Additive

b)      Semi-additive

c)      Non additive

d)     Fact less fact

·         Different kinds of dimensions

a)      Junk dimension

b)      Confirmed dimension

c)      Role playing dimension

d)     Slowly changing dimension

e)      Inferred Dimension

·         Star schema,Snow-flake-schema Dimensional modelling process