|
Informatica is a Data-Warehousing BI tool which provides data integration services that enable organizations to analyse relevant trustworthy data timely. This is a Job Oriented course designed for people looking for Job in Data scientist and Business Analytics.
Duration of this course is 8 Weeks on Weekends Saturday and Sunday 3 Hours Per Day , Trainer is Real Time Working Professional having Expert Knowledge of Informatica ETL. Training Cost is 9,000/- Payable in Two Installments (4,500/- X 2) and Initial Two Classes are Free of Cost in which We Configure Informatica on your Laptop Free of Cost.
Introduction to Data warehousing
1. Overview of a DWH
2. Need of a data warehouse.
3. Data warehouse layer architecture.
4. OLTP/Transactional system and OLAP
5. Meta Data, Granularity, Data Mart
6. Design approach Top down/Bottom up
7. Designing a warehouse using Star/Snowflake schemas.
8. Dimension
9. Fact
10. CDC approach
Introduction to Informatica/ETL tools
1. The role of ETL tools in data warehousing.
2. An introduction to Informatica
3. Informatica Architecture
4. Components/Process flow
Informatica Designer
1. Basic Concepts
2. Using the designer.
3. Working with the Sources-Source Analyzer
4. Working with Relational/Flat file targets- Warehouse Designer.
5. Defining Keys in Informatica.
6. Working with Transformations –Transformation Developer
7. Working with Mapplets- Mapplet designer.
8. Creating mappings –Mapping Designer.
9. Understanding Pipelines in mappings.
10. Setting Target Load order.
11. Configuring Constraint Based loading.
12. Introduction to Mapping Parameters/Variables.
13. Implementing Type1, Type2, and Type3 Mappings.
Working with Transformations
1. Active/Passive Transformations
2. Connected/Unconnected Transformation
3. Importance of Source Qualifier.
4. Filter, Router
5. Expression
6. Sorter, Aggregator
7. Rank
8. Joiner
9. Lookup
10. SQL
11. Stored Procedure
12. Sequence generator
13. Union
14. Update Strategy
15. Xml transformation
Creating Workflows
1. Understanding the server Architecture
2. Working with Workflows
3. Working with Tasks Assignment,Command,Decision,Control,Event raise,
4. Event Wait,Timer,Email,Session Task
5. Working with Work lets
6. Working with Sessions
7. Understanding Commit Points
8. Recovering Data
9. Monitoring Work flows
10. Using Multiple Servers
11. Log files
12. Row Error Logging
13. Session parameters
14. Parameter files
15. Using Incremental Aggregation
Basic oracle and unix only for interview point of view
Mini project
Interview question and scenario
CALL :
09810926239 / 09899209688
WHATSAPP :
09958443384
EMAIL :
paragguide@yahoo.co.in
ADDRESS :
RM Infotech Pvt. Ltd,
332 A, Street No - 6,
West Guru Angad Nagar,
Laxmi Nagar, East Delhi.
(Near Nirman Vihar Metro)
VIEW HADOOP BIG DATA TRAING DETAILS
DEMO CLASS EVERY SATURDAY & SUNDAY CALL 09810926239 or WhatsApp 09958443384 TO BOOK YOUR SEAT
|
WhatApp