Informatica Online Training

                                                              Informatica Training

What is informatica?
Informatica is a powerful ETL tool. Its support all sort of Extraction, Transformation and Load(ETL) activity. Informatica is simple and integration tool. as it includes forms in VB. Drag and Drop objects in design process flow for Data ETL. These process flow diagrams are known as mappings. After creating a mapping it can be used whenever needed. Informatica server extracts,transforms and loads into the target databases.

 It could move huge volumes of web data in a very efficient way, many times better than programs written for specific data movement only. It could effectively join data from two distinct data sources (even a xml file might be joined that has a relational table). Converting raw data and integrating heterogeneous data sources are done effectively with Informatica.

 In Informatica users can use any source of data like Oracle,Teradata,MySQL,MSSQL,Sybase,DB2, File -Cobole Files,XML files,Flat file etc to extract,transform and load(ETL) in formats of database tables, files etc. The process flow diagram is called as mapping.

Once Mapping is manufactured, user can create a session and assign the source and target connection in the case of Database definition or specific the file directory in the case of files.
User can group a number session inside a workflow and it may be schedule to perform when required. In the shadows informatica server deal with fetching data from source, transforming it and loading it to your target system/databases.
What is the use of ETL tool?
 By integrating the details from various source to one place is the method of data warehouse.
Consider for the origination where different department stats are managed in various system like HR department data of company is running in Oracle Application, Finance running in SAP, Supply chain stats are in Mainframe, some stats are residing in Oracle, SQL, VSAM file.
 Firstly to create reports run the reports in different systems and integrate them to obtain a single report.

 Next search the details from various applications and create a data warehouse to generate reports.
To achieve this ETL tool play a large role to extract data from different system, cleanse and transform that and load that into target system.
Today in these days as all companies are moving in global environment and doing a great deal of acquisition, there are plenty of demand coming in data migration and data integration. Informatica plays important role in data migration and data integration.


For more information.

Informatica training, informatica online training, informatica training hyderabad