تفاصيل الدورة
An Informatica is a tool which supports all the steps of Extraction, Transformation and Load process. It is also being used as an Integration tool.Informatica server takes care of fetching data from a source, transforming it and loading it to the target systems or databases.
Informatica can communicate with all major data sources such as mainframe/ RDBMS/ Flat Files/ XML/ VSM/ SAP etc, can move or transform data between them.
It can move large(huge) amount of volume of data in a very effective ;It can also do big updates in small chunks to avoid long locking and filling the transactional log.
It can effectively join data from two different data sources even an XML file can be joined with a relational table.
Informatica has got the ability to integrate heterogeneous data sources and converting raw data into useful information. It enables organizations to gain a competitive benefit in today’s global information economy by empowering companies with relevant and trustworthy data for their top business imperatives. تحديث بتاريخ 27 March, 2023