Learn Informatica in 1 Day: Definitive Guide to Learn Informatica for Beginners by Krishna Rungta
English | 9 Jan. 2017 | ASIN: B01N214GZV | 239 Pages | AZW3/MOBI/EPUB/PDF (conv) | 66.62 MB
English | 9 Jan. 2017 | ASIN: B01N214GZV | 239 Pages | AZW3/MOBI/EPUB/PDF (conv) | 66.62 MB
This is a practical step by step hand-on guide to learn and master Informatica.
Informatica is widely used ETL tool and provided end to end data integration and management solution. This book introduces Informatica in detail. It provides a detailed step by step installation tutorial of Informatica. It teaches various activities like data cleansing, data profiling, transforming and scheduling the workflows from source to target in simple steps, etc.
Chapter 1: Introduction
Chapter 2: Architecture
Informatica Domain
PowerCenter Repository
Domain Configuration
Properties of the domain
Powercenter client & Server Connectivity
Repository Service
Integration Service
Sources & Targets
Chapter 3: Configure Clients and Repositories
What is Informatica domain?
How to Open the Administrator Home Page
How to Create Repository Service
How to create repository contents
How to create Integration Service
How to Configuring client and domain
How to create user
Chapter 4: Source Analyzer and Target Designer
How to open Source Analyzer
How to import Source table in Source Analyzer
How to open Target Designer & import target in target designer
How to create folder in Informatica
Chapter 5: Mappings
Why do you need Mapping?
Components of Mapping
What is Stage Mapping?
How to Create a Mapping
Mapping Parameters and Variables
How to Create Mapping Parameter
How to Create Mapping Variable
Chapter 6: Workflows
Open Workflow Manager
Workflow Monitor
How to open Workflow Monitor
Task View
Gantt Chart View
Chapter 7: Debug Mappings & Session Objects
Steps to use debugger in a mapping
Using breakpoint in debugger
Tracing in Informatica
How to set tracing level in a transformation
Session Objects
Chapter 8: Transformations
Transformations & Filter Transformation
Source Qualifier Transformation
Aggregator Transformation
Router Transformation
Joiner Transformation
Rank Transformation
Sequence Generator Transformation
Transaction Control Transformation
Lookup and Re-usable Transformation
Normalizer Transformation
Performance Tuning for Transformation
Chapter 2: Architecture
Informatica Domain
PowerCenter Repository
Domain Configuration
Properties of the domain
Powercenter client & Server Connectivity
Repository Service
Integration Service
Sources & Targets
Chapter 3: Configure Clients and Repositories
What is Informatica domain?
How to Open the Administrator Home Page
How to Create Repository Service
How to create repository contents
How to create Integration Service
How to Configuring client and domain
How to create user
Chapter 4: Source Analyzer and Target Designer
How to open Source Analyzer
How to import Source table in Source Analyzer
How to open Target Designer & import target in target designer
How to create folder in Informatica
Chapter 5: Mappings
Why do you need Mapping?
Components of Mapping
What is Stage Mapping?
How to Create a Mapping
Mapping Parameters and Variables
How to Create Mapping Parameter
How to Create Mapping Variable
Chapter 6: Workflows
Open Workflow Manager
Workflow Monitor
How to open Workflow Monitor
Task View
Gantt Chart View
Chapter 7: Debug Mappings & Session Objects
Steps to use debugger in a mapping
Using breakpoint in debugger
Tracing in Informatica
How to set tracing level in a transformation
Session Objects
Chapter 8: Transformations
Transformations & Filter Transformation
Source Qualifier Transformation
Aggregator Transformation
Router Transformation
Joiner Transformation
Rank Transformation
Sequence Generator Transformation
Transaction Control Transformation
Lookup and Re-usable Transformation
Normalizer Transformation
Performance Tuning for Transformation