Informatica 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.
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!