Informatica Developer Tool- Informatics developer was developed by Informatica
Corporation in the year 1993. This company is well known for
data integration product Power Centre. Informatics
Developer is a tool where data quality plans or maps are
developed. It is a software development kit (SDK) with set of API’s to extend
the functionality of power centre platform. Informatica tool contains all the
transformation of power centre related to data quality.
Starting Date | Timings | Ending Date | |
---|---|---|---|
Wed Oct 2020 | 2PM - 4PM | Tue Nov 2020 |
Ø
Introduction
to ETL Logic
Ø
Overview
of Staging Area
Ø
Need
of ETL Logic
Ø
Difference
between OLTP systems and OLAP systems
Ø
Overview
on Data Warehousing concepts
Ø
Introduction
to Data Modeling
Ø
Overview
on Database
Ø
Construction
of DWH/Data marts using ETL logic
Ø
Introduction
to Informatica Power Center
Ø
Difference
between various versions of Power center
Ø
Overview
of sub tools of the Informatica Power Center:
Ø
Informatica
client:
Ø
Working
with Power center administrative console
ASCII and Unicode
Ø Informatica Designer:
·
Mapping
designer
Ø
Workflow
manager:
Ø
Transformations:
1)
Source
qualifier
2)
Expression
3)
Aggregator
4)
Rank
5)
Filter
6)
Router
7)
Lookup
a) Connected
b) Unconnected
c) Difference between
Dynamic Lookup, Static Lookup, Persistence Lookup
And Re-cache from the
source
8)
Stored
Procedure and function
a) Connected
b) Unconnected
9)
Update Strategy
10) Transaction control
11) Normalizer
12) Sequence generator
13) Union
14) Joiner ( Normal, Master
outer, detail Outer, Full Outer)
15)
XML Source qualifier
16)
Sorter
17)
Mapplet input
18)
Mapplet Output
Ø Advanced
Transformations:
Java
Transformation
Sql
Transformation
HTTP
transformation
SAP
R/3 Transformation
Mapping
designer:
Ø
Best
practices when building mappings
Ø
Construction
of complex mappings for dimension tables
and fact tables
Ø
Dimension
mappings:
(Hybrid Dimension-HSCD).
·
Construction
of the complex mappings for Data warehousing
·
Creation
of the cubes
·
Analysis
of Business user requirements
Ø
Combined
type-1,type-2 and type-3 in a single mapping
Ø
Working
with SCD wizards
Ø
Working
with Rapidly Changing dimensions (RCD).
Ø Development of the
target tables based on business user requirements
Ø Source analyzer:
Ø
Target
designer:
Ø
Differences
between source qualifier and joiner transformation with practical explanation
Ø
Difference
between filter and router transformations with practical explanation
Ø
Difference
between expression and aggregator transformation with practical explanation
Ø
Overview
of the workflow manager
Ø
Explanation
of the different types of the memories
·
Buffer,
Cache
Ø
Overview
of the load manager
Ø
Overview
of the Data transformation manager
Ø
Overview
of different types of tasks:
Ø
Execution
of the mappings:
Ø
Loading:
Ø
Lookup
cache:
Ø
Introduction
to Load Manager (LM)
Ø
Overview
on DTM (Data Transformation Manger)
Ø
Working
with Parallel pipeline partitioning mechanism:
Source level,
transformations level and target level.
Ø
Introduction
Threads
Ø
Types
of threads:
·
Reader
thread
·
Transformation
thread
·
Writer
thread
·
Pre-session
thread
·
Post-session
thread
Ø
Analysis
of BRS
Ø
Development
of RRS
Informatica
developer replaces the traditional Informatica data quality.
Informatica
is a open ended system that supports multiple platforms and multiple data
management environment. Informatica
sessions can be arranged in folders based on the worklets and work flows. This
leads to an environment which is easy to maintain and quicker to analyze and
enhance Popular
Course in this category This tool
enables easy access and cleansing of any type of data from any source and in
any mode within the enterprise or in partner’s system or in the cloud or
in Hadoop. Informatica
is an independent player to solve to solve customers’ problems. There is no
proprietary system to protect and no set of standards to impose. It offers you
the choice to choose what works best for your environment. Informatica
lets you to monitor the jobs easily by means of Informatica
Workflow Monitor. It also lets you restart failure jobs from
particular row or step. Informatica also lets you discover and recover the failed
jobs Informatica
market place contains lot of tools and accelerators to improve the application
support Informatica
acts as connectors to various databases including Teradata mLoad, tPump, FastLoad and
Parallel Transporter. There are
also few connectors for which you need to invest an extra cost. One example of
such source is social media sites like
Facebook, Twitter, and others. Informatica
enables its team members and business to share the data profiles and quality
cards easily through bookmarks and providing comments in notes section. Informatica
is the market’s leading data integration platform. It provides to its customers
what they want and a data integration solution that can integrate with more
data from various sources and in a very minimum time and effort. Informatica
is known for its innovation. Its data integration platform is developed to meet
the challenging data integration requirements. It has a architectural approach
and has a consistent record of delivering solid technologies to its customers.
Thus it attracts many customers.
Informatica
has developed a support organization which offers superior service. The support
team has developed a clear set of rules and procedures to approach a problem
and find a solution for that. The support system has a centralized call logging
and tracking system that will help in arranging the issues based on its
priority and severity. All graduates and post graduates
Prerequisites
What are the objectives?
Why to Learn this course?
Who should go for this training?
Additional Data
Advantages of Informatica