1 / 10

Informatica Training By Informatica Training Classes

Emphasis is given on important topics which are essential and mostly used in real time projects. INFORMATICA TRAINING CLASSES is an Online Training Leader when it comes to high-end effective and efficient I.T Training. We have always been and still are focusing on the key aspects which are providing utmost effective and competent training to both students and professionals who are eager to enrich their technical skills. Training Features at INFORMATICA TRAINING CLASSES: We believe that online training has to be measured by three major aspects viz., Quality, Content and Relationship with the Trainer and Student. Not only our online training classes are important but apart from that the material which we provide are in tune with the latest IT training standards, so a student has not to worry at all whether the training imparted is outdated or latest. Course content: • Basics of data warehousing concepts • Power center components • Informatica concepts and overview • Sources • Targets • Transformations • TYPES Of LookUp Caches • Task Types • Advanced Informatica concepts • Informatica Coding Standards & Best Practices used in real time development Please Visit us for the Demo Classes, we have regular batches and weekend batches. INFORMATICA ONLINE TRAINING CLASSES Phone: (404)-900-9988 Email: info@informaticatrainingclasses.com Web: http://informaticatrainingclasses.com

Download Presentation

Informatica Training By Informatica Training Classes

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.


Presentation Transcript

  1. Informatica Online Training BY Informatica Training Classes Contact : 404-900-9988 Email : info@informaticatrainingclasses.com Website : www.informaticatrainingclasses.com

  2. What Is Informatica? Informatica is the best ETL tool in the market. It is capable of extracting data from multiple heterogeneous sources, transforming them as per business requirement and loading to target tables. Its used in Data migration and loading projects. It is a visual interface and you will be dragging and dropping with the mouse in the Designer(client Application).This graphical approach to communicate with all major databases and can move/transform data between them. It can move huge bulk of data in a very effective way.

  3. What Is Informatica? Informatica's product is a portfolio focused on Data Integration: ETL, Information Lifecycle Management, B2B Data Exchange, Cloud Data Integration, Complex Event Processing, Data Masking, Data Quality, Data Replication, Data Virtualization, Master Data Management, Ultra Messaging Informatica comes in different packages: Informatica Power Center license - has all options, including distributed metadata, ability to organize repositories into a data mart domain and share metadata across repositories. PowerMart PowerMart - a limited license (all features except distributed metadata and multiple registered servers)Working

  4. Informatica Advantages PowerCenter provides reliable solutions to the IT management, global IT teams, developers and business analysts as it delivers not only data that can be trusted and guarantees to meet analytical and operational requirements of the business, but also offers support to various data integration projects and collaboration between the business and IT across the globe. Informatica PowerCenter enables access to almost any data sources from one platform. It is possible thanks to the technologies of Informatica Power Exchange and PowerCenter Options.

  5. Why Informatica Data is—and has been from the beginning—created, stored, and retrieved by disparate, incompatible systems. Between 30% and 35% of all the data in the industry is still on mainframes, in languages and data structures that are archaic and generally unavailable. The wave of specialty applications—HR, sales, accounting, ERP, manufacturing—have all contributed their share to the chaos. The latest (and perhaps most disruptive) development—the growth in outsourcing, in all kinds and flavors, including business processes, IT management, and geographic, will add even more complexity to the mix.

  6. Informatica Introduction Definitions: 1. Source Qualifer: It reads data from flat file and relational sources 2. XML Source Qualifier: Reads XML data 3. Normalizer: It re organizes records from VSAM, Relational and Flat File 4. Expression: It performs row-level calculations 5. Aggregator: It performs aggregate calculations 6. Filter: It drops rows conditionally 7. Router: It splits rows conditionally 8. Sorter: Sorts data from any source, at any point in a data flow 9. Update Strategy: It tags rows for insert, update, delete, reject 10. Lookup: It looks up values and passes them to

  7. Informatica Introduction Transformation:- It's an object which allows to define the business logic for processing the data. There are two types of Transformations 1. Active Transformation An Active Transformation can change the number of rows that pass through the transformation, change the transaction boundary, can change the rqow type. 2. Passive Transformation A Passive Transformation does not change the number of rows that pass through it, maintains the transaction boundary and maintains the row type.

  8. Informatica Highlights As Informatica World 2014 drew to a close, there was no longer any doubt: the hundreds of ‘data geeks’, ‘data divas’, ‘data kings’ and ‘data queens’ in attendance were going back to the office to fundamentally change the way their companies worked 1. The Empowered Business User A consistent theme running through all the keynotes and customer sessions was IT’s evolving relationship with the non-technical business user. 2. The need for strategic data governance “Enduring, comprehensive and omni-purpose.”

  9. Informatica Online Training • Informatica Online Training supports to read data from various relational databases, after reading data from source we will transform that data based on our requirement and then load that data into data warehouse. • This process of extracting, transforming and loading is called data acquisition. Informatica Power Centre is used to maintain current data and historical data but in ordinary databases we can only maintain current data. • In Informatica we will do most of the work by simply dragging and dropping with mouse in the Informatica designer. This makes it very easy to understand the users what is going on. Informatica can also be used as a Integration tool.

  10. Informatica Online Training Informatica is a widely used ETL tool for extracting the source data and loading it into the target. When applying the desired transformation, Informatica permits organizations to achieve a competitive advantage in today’s global data economy by empowering firms with timely, relevant and trustworthy data for their prime business imperatives. Informatica is a company that offers the following tools Informatica power centre Informatica power exchange Informatica reporting services

More Related