WIXLIB

2 Lan Dr.Westford, MA, 01886Phone: 1 855 451 0451hr@logandata.comwww.logandata.comTechnical Deep Dive in Informatica V10Modified: 01-28-2016Author: Amaresh, VictorLast Updated: 01-29-2016Version Number: 0.2Contact Info: amareshrm@logandata.comjiangshanc@logandata.com

2 Lan Dr.Westford, MA, 01886Phone: 1 855 451 0451hr@logandata.comwww.logandata.comAbout us Logan Data Inc. is a customer-centric service provider for data consulting services and solutionsin the New England Area, with an expertise in the Data Integration, Data Warehouse, BusinessIntelligence and Big Data practices.Our Client is a NE based data solution provider in the healthcare industry. Our clients realizeminimized risk, improved project efficiency and increased speed of transformation, whilefacilitating more predictable, ongoing technical operations. This includes services for DataIntegration, Data warehouse, Data Profiling, Data Quality, Master Data Management, Healthcheck for tools and processes. We also offer complete Data solution packages like Storage,Maintenance and Secure PHI data protection.What’s new with version 10 Informatica? Overview of new features .

2 Lan Dr.Westford, MA, 01886Phone: 1 855 451 0451hr@logandata.comwww.logandata.comInformatica v10 & its features:Informatica has announced the release of Informatica v10, an update to the datamanagement platform that improves upon its previous version with both featureupgrades and performance improvements. Reaching data structures across the moderntechnical landscape, Informatica v10 is able to make connections to enterprise data,whether it's stored in the cloud or under a desk on an old workstation, and use that datato deliver insights, gain productivity and apply governance.Informatica v10 is purpose-built to deliver great data at nearly any speed across today’shybrid IT environments, both cloud and on premise. The solution is designed to deliverperformance, flexibility, usability, governance and productivity across its three corecomponents –Three core components of the release are:1. Informatica PowerCenter2. Informatica Data Quality and3. Informatica Data Integration HubInformatica PowerCenter, Informatica Data Quality and Informatica Data Integration Hub Lead thePack with Enhanced Agility and Performance Combined with New Features Up to 50x faster data lineage generation Up to 5x faster data ingestion and cleansing Increased flexibility and agility for hybrid data architecturesFeatures that are worth mentioning:

2 Lan Dr.Westford, MA, 01886 FasterDataPhone: 1 855 451 0451hr@logandata.comwww.logandata.comIntegratio nformoderndatawarehouses – Up to 5xfaster data ingestion for Oracle Exadata, Oracle SuperCluster, SAP Hana and HP Vertica.PowerCenter v10 is certified as optimized for all these targets. Better IT-Business CollaborationoNew visualizations are available for data discovery and profiling. It helps to improveour understanding of the data.o100 analyst tool seats are included for IT-Business collaboration for agile dataintegration development. Rapid Prototyping Capability – Allows prototypes to be developed in a timelyfashion to refine or validate data requirements. Real-TimeEngine(AdvancedVersion) – Empowers real-time datawarehousing and exchange data among applications according to the requirements batch, near real time or in real time. MetadataManagerandDataLineage(AdvancedVersion) – NowMetadata Manager has up to 50X faster data lineage rendering though the use of graphdatabase technology. Business Glossary (Advanced Version) – Empowers Data Governance taskssuch as voting on business terms and has approval workflow built-in.Three highlights of the release are Informatica PowerCenter, Informatica Data Quality and Informatica DataIntegration Hub.

2 Lan Dr.Westford, MA, 01886Phone: 1 855 451 0451hr@logandata.comwww.logandata.comInformatica Power Center When Informatica version 9.6 was released, PowerCenter was itself at the center of a push fromInformatica to get the business analysts working more closely with their IT counterparts. This meantmaking it possible to take the end-to-end data visibility and integration out of the hands of the ITpersonnel and let the data users be able to get the reports and data visualizations they required fortheir jobs. In version 10, Informatica has increased the performance of PowerCenter dramaticallyover the previous version and added features that support those business users. Operations generating data lineage through PowerCenter can be completed up to 50x faster; dataingestion from sources including Oracle Exadata, Oracle SuperCluster, SAP Hana and HP Verticahas been optimized, with imports streaming in up to 5x faster. New features in this version of PowerCenter include a real-time engine that provides an on-rampto data warehousing, as well as advanced data transformation utilities for parsing and translatingdata of all types and sizes. Additionally, to help ease that transition from IT support owning the dataand setting up the reports and visualizations to business analysts taking care of their own,Informatica v.10 comes with 100 analyst tool seats, enabling IT-to-business-user collaboration.Informatica Data Quality Informatica Data Quality continues its tradition of cleansing and qualifying data according tobusiness rules defined by business strategies and IT architectures. Improvements in Data Qualityinclude Informatica Vibe, which allows the rules to be created against one data set and then appliedvirtually anywhere – whether in the cloud or on-premises. Performance increases over previous versions are again a big win for Informatica v.10, whichboasts a 5x faster data cleansing operation on Oracle Exadata, Oracle SuperCluster, SAP Hanaand HP Vertica.

2 Lan Dr.Westford, MA, 01886Phone: 1 855 451 0451hr@logandata.comwww.logandata.comInformatica Data Integration Hub Informatica Data Integration Hub is a "Pub-Sub-Hub," which describes the ability to locate all ofyour data into a single place (that is, the hub) and be able to both publish and subscribe to datathat is presented. The efficiency of the Integration Hub allows for large scale operations, such asthe automated storage of petabyte-scale Hadoop data lakes, but some of the most nuanced usecases for the Data Integration Hub is its ability to modernize old data stores. As organizations mature, data sprawl begins to occur. Like a "Big Bang" of data, what was oncecentrally located on a mainframe or a centralized database slowly but assuredly makes it way tosmaller and less controlled devices. Everyone knows of "that one Microsoft Access" database thatjust won't go away, was programmed years ago by somebody now long gone, and has becomeboth mission critical and critically obsolete. By connecting into these old data stores, a company isable to leverage the data stored in those mission critical sources and present it in modern ways –connect it to related data, manage it like a modern cloud service, and present it to data workers inremote offices.

2 Lan Dr.Westford, MA, 01886Phone: 1 855 451 0451hr@logandata.comwww.logandata.com

2 Lan Dr.Westford, MA, 01886Phone: 1 855 451 0451hr@logandata.comwww.logandata.comLet me summarize some of the interesting themes here. Anil Chakravarthy – CEO – Informatica Corp, in his words: “The best in data integrationand data quality solutions just got better.” As the leader in all things data for the past 20years, Informatica has raised the bar yet again. Today data drives businesses andInformatica is synonymous with all things data. With Informatica v10, architects canmodernize their IT environment by leveraging top performance and improved datagovernance for modern data warehouses, along with the flexibility of full Cloud supportvia a data hub, and increased end-to-end data integration agility.” What is the main reason to choose Informatica? The overwhelming response is; “Theproductivity of the environment. We get more done faster and more repeatedly.” In theversion 10 release, new features will accelerate the productivity of customer on their firstproject – and continue to drive productivity as they grow to additional projects.Here are a couple of quick examples: The Data Profiling tool now has been enhanced withreally nice data visualization capabilities to make it far easier and faster to understand ourdata and its relationships. Another addition is 100 free Analyst Tool seats to all editionsof PowerCenter. Informatica has been driving agile data integration development basedon the idea of a development team made up of a developer and a business analyst. Theaddition of free Analyst Tools makes it even easier to make agile DI development astandard practice to speed up interaction and collaboration between business and IT,speeding business value delivery. The last big theme here cover is automation: Informatica is building automation into ourtools to drive productivity so that organizations can scale up in data and the growth ofdata users and use cases.

2 Lan Dr.Westford, MA, 01886 Phone: 1 855 451 0451hr@logandata.comwww.logandata.comAs organizations scale up their operations, it becomes more and more important to beable to “manage data as an asset.” There has been an enormous amount of work done inthis release to make the user experience easier and more productive across all of theproducts. A great deal of this translates into improvements that directly relate to datagovernance. Another key enhancement is the new Business Rule Builder in Data Quality.This enables business people to create new business rules in simple language that the toolcan take and convert into an Informatica mapping. This is very powerful. With version 10, the story gets even stronger, for a lot of different reasons. Informatica10 is what we need to get started on our first data integration and data quality projects.It also provides a very natural evolution to multiple projects and to the creation of amodern data architecture.If we are looking to drive productivity in our dataenvironment, increase development agility, improve data governance, and build towardsour vision for the data architecture of the future, we really need to consider moving toInformatica 10 now.

2 Lan Dr.Westford, MA, 01886Phone: 1 855 451 0451hr@logandata.comwww.logandata.comOverview of version 10 Informatica new features . Team based development and version control support for IDQ Model Repository Service. Big Data Management Configuration Utility to automate part of the configuration process for BigData Management. Enhancements to Business Glossary for Email Notification, Approval Workflow and Import/Export. Various enhancements to command line programs. Enhancements to Informatica Admin Console for Bird’s eye view of the Domain and Service healthand Monitor progress of Jobs in detail. New Profile UI and Visualizations. Features to compare the historical profile run and outlierdetection. Support for profiling on XML/JSON file and scorecard filters. Dynamic mappings to change sources, targets, and transformation logic at run time based onparameters and rules that you define. Various enhancements to Metadata Manager. Various enhancements to PowerExchange Adapters. Native Connectivity to Microsoft SQL Server from UNIX machines. Major enhancements on parameterization in Mercury for better re-usability of the artifacts. Partitioning support in Mercury platform.