05-02-2016, 06:03 PM
I am beginner and I need Informatica study material.
Kindly help me.
|
informatica beginners study material pdf
|
I am beginner and I need Informatica study material.
Kindly help me.
06-02-2016, 11:55 AM
informatica beginners study material pdf
Introduction to Informatica
What is Informatica?
Informatica is a tool, supporting all the steps of Extraction, Transformation and Load process. Now a days Informatica is also being used as an Integration tool.
Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases.
Informatica can communicate with all major data sources (mainframe/RDBMS/Flat Files/XML/VSM/SAP etc), can move/transform data between them. It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement only. It can throttle the transactions (do big updates in small chunks to avoid long locking and filling the transactional log). It can effectively join data from two distinct data sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information.
In short, Informatica is worlds leading ETL tool & its rapidly acquiring market as an Enterprise Integration Platform.
Informatica Software Architecture
Informatica Software Architecture illustrated
Informatica ETL product, known as Informatica Power Center consists of 3 main components.
1. Informatica PowerCenter Client Tools:
These are the development tools installed at developer end. These tools enable a developer to
Define transformation process, known as mapping. (Designer)
Define run-time properties for a mapping, known as sessions (Workflow Manager)
Monitor execution of sessions (Workflow Monitor)
Manage repository, useful for administrators (Repository Manager)
Report Metadata (Metadata Reporter)
2. Informatica PowerCenter Repository:
Repository is the heart of Informatica tools. Repository is a kind of data inventory where all the data related to mappings, sources, targets etc is kept. This is the place where all the metadata for your application is stored. All the client tools and Informatica Server fetch data from Repository. Informatica client and server without repository is same as a PC without memory/harddisk, which has got the ability to process data but has no data to process. This can be treated as backend of Informatica.
3. Informatica PowerCenter Server:
Server is the place, where all the executions take place. Server makes physical connections to sources/targets, fetches data, applies the transformations mentioned in the mapping and loads the data in the target system.
Informatica Corporation is a software company founded in 1993 by Gaurav Dhillon and Diaz Nesamoney. Informatica Corporation is well known for its data integration (ETL) product PowerCenter. A lot of times when people say Informatica they actually mean Informatica PowerCenter!
Over the course of last 10 years Informatica has introduced a series of products – all related to Data Integration & Warehousing. A quick list of Informatica products is right here:
PowerCenter
B2B Data Exchange
MDM – Master Data Management
TDM/ILM – Test Data Management / Information Lifecycle Management / Data Archive
Informatica Data Masking / Dynamic Data Masking
iPaaS – Integration Platform as a Service
Informatica Data Virtualization
Now that you have an idea about the company and products lets talk about PowerCenter.
Informatica PowerCenter is a tool, supporting all the steps of Extraction, Transformation and Load process. A whole lot of product offerings are orchestrated around PowerCenter’s ability to connect to different technologies ranging from mainframe to CRM to Big Data.
Informatica PowerCenter is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is developed, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases.
PowerCenter can communicate with all major data sources (mainframe, Big Data, RDBMS, Flat Files, XML, SAP, Salesforce & the list goes on), can move/transform data between them. It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement. It can throttle the transactions (do big updates in small chunks to avoid long locking and filling the transactional log). It can effectively join data from two distinct data sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information.
Some facts and figures about Informatica Corporation:
Founded in 1993, based in Redwood City, California
5500 + Employees; 5000 + Customers
NASDAQ Stock Symbol: INFA; Stock Price: $48.73 (11/06/2015)
Revenues in fiscal year 2014: $1.05 Billion
In short, Informatica is worlds leading ETL tool & its rapidly acquiring market as an Enterprise Integration Platform.
Introduction to Informatica
What is Informatica?
Informatica is a tool, supporting all the steps of Extraction, Transformation and Load process. Now a days Informatica is also being used as an Integration tool.
Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases.
Informatica can communicate with all major data sources (mainframe/RDBMS/Flat Files/XML/VSM/SAP etc), can move/transform data between them. It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement only. It can throttle the transactions (do big updates in small chunks to avoid long locking and filling the transactional log). It can effectively join data from two distinct data sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information.
In short, Informatica is worlds leading ETL tool & its rapidly acquiring market as an Enterprise Integration Platform.
Informatica Software Architecture
Informatica Software Architecture illustrated
Informatica ETL product, known as Informatica Power Center consists of 3 main components.
1. Informatica PowerCenter Client Tools:
These are the development tools installed at developer end. These tools enable a developer to
Define transformation process, known as mapping. (Designer)
Define run-time properties for a mapping, known as sessions (Workflow Manager)
Monitor execution of sessions (Workflow Monitor)
Manage repository, useful for administrators (Repository Manager)
Report Metadata (Metadata Reporter)
2. Informatica PowerCenter Repository:
Repository is the heart of Informatica tools. Repository is a kind of data inventory where all the data related to mappings, sources, targets etc is kept. This is the place where all the metadata for your application is stored. All the client tools and Informatica Server fetch data from Repository. Informatica client and server without repository is same as a PC without memory/harddisk, which has got the ability to process data but has no data to process. This can be treated as backend of Informatica.
3. Informatica PowerCenter Server:
Server is the place, where all the executions take place. Server makes physical connections to sources/targets, fetches data, applies the transformations mentioned in the mapping and loads the data in the target system.
Informatica Corporation is a software company founded in 1993 by Gaurav Dhillon and Diaz Nesamoney. Informatica Corporation is well known for its data integration (ETL) product PowerCenter. A lot of times when people say Informatica they actually mean Informatica PowerCenter!
Over the course of last 10 years Informatica has introduced a series of products – all related to Data Integration & Warehousing. A quick list of Informatica products is right here:
PowerCenter
B2B Data Exchange
MDM – Master Data Management
TDM/ILM – Test Data Management / Information Lifecycle Management / Data Archive
Informatica Data Masking / Dynamic Data Masking
iPaaS – Integration Platform as a Service
Informatica Data Virtualization
Now that you have an idea about the company and products lets talk about PowerCenter.
Informatica PowerCenter is a tool, supporting all the steps of Extraction, Transformation and Load process. A whole lot of product offerings are orchestrated around PowerCenter’s ability to connect to different technologies ranging from mainframe to CRM to Big Data.
Informatica PowerCenter is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is developed, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases.
PowerCenter can communicate with all major data sources (mainframe, Big Data, RDBMS, Flat Files, XML, SAP, Salesforce & the list goes on), can move/transform data between them. It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement. It can throttle the transactions (do big updates in small chunks to avoid long locking and filling the transactional log). It can effectively join data from two distinct data sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information.
Some facts and figures about Informatica Corporation:
Founded in 1993, based in Redwood City, California
5500 + Employees; 5000 + Customers
NASDAQ Stock Symbol: INFA; Stock Price: $48.73 (11/06/2015)
Revenues in fiscal year 2014: $1.05 Billion
In short, Informatica is worlds leading ETL tool & its rapidly acquiring market as an Enterprise Integration Platform.
|
« Next Oldest | Next Newest »
|
