There are separate tools available for different roles. Informatica has the capability to pull data from IMS, DB2 on series and series and from other several other legacy systems (Mainframe) environment like VSAM, Datacom, and IDMS etc.ġ7. It provides browser based tool for analysts to support the types of tasks they engage in, such as profiling data, specifying and validating rules & monitoring data quality.ġ5. The developer tool is now eclipse based and supports both data integration and data quality for enhanced productivity. Both tools incorporate security features like authentication and authorization ensuring.ġ4. The ability to define rules and view and run profiles is available in both the Informatica developer (Thick client) and Informatica analyst (browser based tool-Thin client).these tools sit on a unified metadata infrastructure. Informatica data quality provides worldwide address validation support with integrated geo coding.ġ3. The data services capabilities in Informatica 9, both over sql and web services ,can be used for real time dash boarding.ġ2. The mappings rules are shared between the browser based tool for analysts and the eclipse based development leveraging unified metadata underneath.ġ1. In Informatica 9, Informatica data quality (IDQ) has been further integrated with the Informatica Platform and performance, manageability and reusability have all been significantly enhanced.ġ0. Single admin console for data quality, power centre, power exchange and data services.ĩ. Powerful new capabilities for data quality.Ĩ. Allows unified administration with a new admin console that enables you to manage power centre and power exchange from the same console.ħ. Browser based tool for business analyst is a new feature.Ħ. There is architectural difference in Informatica 9 compared to previous version.Ĥ. Informatica analyst is a new tool available in Informatica 9.ģ. You can integrate the data in cloud applications, as well as run Informatica 9 on cloud infrastructure.Ģ. Informatica 9 supports data integration for the cloud as well as on premise. IDQ Match Transformation (Field Matching Strategies)īigram: Use the Bigram strategy to compare long text strings, such as postal addresses entered in a single field.1.I found this interesting KB article from Informatica on How to handle Keys in Datamart/DWH Interesting Topic about How to handle Keys in Datamart/DWH. Match Tx: The Match transformation is an active transformation that calculates the degree of similarity between input records and generates output data for these calculations.…
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |