Informatica and Datawarehousing Concepts

LIVE

Ongoing

Course offered by Kiran Krishna

0 review

overview batches reviews

Courses Details:

ORACLE:

DDL,DML.TCL,DRL,DCL
Differences Between sub queries and Co-related sub queries
Group by functions
Query performance Tuning techniques
Basic PL/SQL

BI and DWH Concepts:

BI & its Role in Organizations?
BI Tools.
How to build/design DWH?
Data Modeling- Different models in building, SchemasSubject Areas, Data Marts
Dimension Tables
Fact Tables
Fact less fact tables
Bridge Tables
Introduction to Data Warehousing?
What is OLTP & OLAP
Why we need DWH in real-time.
Differences among data marts, databases & DWH
Star schema and Snow flake schema

ETL [Extraction, Transformation, Loading]:

What is ETL?
Why we need ETL in Data Warehousing?
ETL Architecture?
Importance of Data Integration

Informatica Power Center â?? V 9.1.0

Introduction to Informatica
Difference between informatica 7 X and 8 X
Server Components
Client Components
Informatica Architecture
All Transformations with real time examples?
Parameters and Variables
Usage of Parameterization
Creating Parameter Files
Creating Mappings for different real time project based scenarios.
Task
Worklet
Workflows
Connections objects
Scheduling

UNIX:

What is Unix requirement in Informatica Projects
Basic real time Unix shell scripts

Â

About the Trainer

Avg Rating

0 Reviews

4 Students

3 Courses

Kiran Krishna

BTECH,PGDM

7 Years of Experience

Professional Summary:
Data warehousing experience using Informatica Power Center 8.x 9.x & ETL Concepts.
Extensively worked on Informatica Designer Components -Source Analyzer, Mapping Designer, Mapplet Designer and Transformation Developer.
Developed and supported Extraction, Transformation and Load process (ETL) using Informatica Power Center to populate the tables in Data marts.
Ã¯?? Hands on experience with mappings with varied transformation logics like Unconnected and Connected lookups, Expression, Filter, Router, Aggregator, Joiner, Update Strategy and Re-usable transformations.
Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat Files and Oracle.
Good knowledge and hands on SQL and PL/SQL.
Having Knowledge and hands on UNIX Environment.
Having Knowledge and Hands on Third Party Scheduling Tool DAC10g/11g .
Diverse background with fast learning skills and creative analytical skills.
Good communication skills, interpersonal skills, team coordination and versed with Software Development processes.