Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - 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.




810
views
asked oitallinfo August 7, 2013 02:25 AM  

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.


           

1 Answers


Your answer

Join with account you already have

FF

Preview


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!

Alert