subject: Informatica And Its Origin By Best Online Trainers [print this page] Informatica is a powerful ETL toolInformatica is a powerful ETL tool. Its support all type of Extraction, Transformation and Load(ETL) activity.Informatica has got a simple visual interface, user can use any type of source (Dtatabase table-Oracle,Teradata,MySQL,MSSQL,Sybase,DB2, File Cobole Files,XML files,Flat file etc) to extract data, use the inbuilt transformation to transform the data and load the data in any of the desired format like Database tables , files etc. These process flow diagram are known as mappings.
Once Mapping is made, user can create a session and assign the source and target connection in case of Database definition or specific the file directory in case of files.User can group one or more session in a workflow and it can be schedule to run as and when required. In the background informatica server take care of fetching data from source, transforming it and loading it to the target system/databases.
To consolidate the data from different source to one place the concept of Data warehouse came into picture.Consider for an origination where his different department data is managed in different system like HR department data of company is running in Oracle Application, Finance running in SAP, Supply chain data is in Mainframe, some data is stored in Oracle, SQL, VSAM file.
First approach, to generate the report, run reports on different system and consolidates to get one single report.Second approach, fetch the data from different systems/application and make a data warehouse and generate reports as per the requirement. To achieve this ETL tool play a significant role to extract data from different system, cleanse and transform that and load that into target system.Now a days as all companies are going in global environment and doing lots of acquisition, there are lots of demand coming in the field of data migration and data integration. An ETL tools play a signification role in the data migration and data integration fields.
The aggressive foreign processing technique as well as a requirement of simplicity of use encouraged health marketplace advertising firm PDI Inc. to choose the Informatica Fog up data integration program around competing solutions from Boomi Inc., firm administrators said within the job interview.
The Parsippany, N.J.-based PDI Inc. -- which handles marketing activities for pharmaceutical firms and healthcare providers -- also evaluated hosted offerings from Adeptia Inc. and Magic Software Enterprises Ltd. before ultimately settling on Informatica Cloud for its data integration needs.
