Transcription
Informatica CertificationTrainingInformatica Certification Training1 Page
Table of Contents1.About the Program2.About Intellipaat3.Key Features4.Career Support5.Why take up this course?6.Who should take up this course?7.Program Curriculum8.Project Work9.Certification10.Intellipaat Success Stories11.Contact UsInformatica Certification Training2 Page
About the ProgramInformatica training provided by Intellipaat helps you be a master in PowerCenter ETL tool,data integration, and data warehousing, among other concepts. This Informatica coursewill help you clear the PowerCenter Developer Certification exam. You will also masteradvanced concepts such as installation and configuration, Informatica architecture,advanced Informatica transformations, and performance tuning.About IntellipaatIntellipaat is one of the leading e-learning training providers with more than 600,000learners across 55 countries. We are on a mission to democratize education as webelieve that everyone has the right to quality education.Our courses are delivered by subject matter experts from top MNCs, and our world-classpedagogy enables learners to quickly learn difficult topics in no time. Our 24/7 technicalsupport and career services will help them jump-start their careers in their dreamcompanies.Informatica Certification Training3 Page
Key Features42 HRS INSTRUCTOR-LEDTRAINING42 HRS SELF-PACED TRAINING60 HRS REAL-TIMEPROJECT WORKLIFETIME ACCESS24/7 TECHNICAL SUPPORTINDUSTRY-RECOGNIZEDCERTIFICATIONJOB ASSISTANCE THROUGH80 CORPORATE TIE-UPSFLEXIBLE SCHEDULINGInformatica Certification Training4 Page
Career SupportSESSIONS WITH INDUSTRY MENTORSAttend sessions from top industry experts and get guidance on how to boostyour career growthMOCK INTERVIEWSMock interviews to make you prepare for cracking interviews by top employersGUARANTEED INTERVIEWS & JOB SUPPORTGet interviewed by our 400 hiring partnersRESUME PREPARATIONGet assistance in creating a world-class resume from our career services teamInformatica Certification Training5 Page
Why take up this course? The Cloud Analytics market to be worth US 23.1 billion in the next 2 years –MarketsandMarkets Informatica PowerCenter is the most widely adopted ETL technology – ForresterResearchInformatica is the market leader in the ETL segment. It can work on a wide variety ofdatasets, varying standards, and multiple applications and systems. Thus, it is rapidlybeing adopted by organizations around the world, providing huge job opportunities forprofessionals with the right set of skills. Intellipaat’s Informatica online classes will prepareyou for clearing the Informatica certification exam.Who should take up this course? Business Intelligence, ETL, SQL, and Database Professionals Project Managers Graduates looking to make a career in BIInformatica Certification Training6 Page
Program CurriculumInformatica Training Course Content DATA WAREHOUSING & CLEANSING CONCEPTSWhat is data warehousing? Understanding the extract, transform, and loadprocesses, data aggregation, data scrubbing, and data cleansing, and theimportance of Informatica PowerCenter ETL INFORMATICA INSTALLATION & CONFIGURATIONConfiguring the Informatica tool and how to install the Informatica operationaladministration activities and integration servicesHands-on Exercise: Step-by-step process for the installation of InformaticaPowerCenter WORKING WITH ACTIVE & PASSIVE TRANSFORMATIONUnderstanding the difference between active and passive transformations and thehighlights of each transformation WORKING WITH EXPRESSION TRANSFORMATIONLearning about expression transformation and connected passive transformation tocalculate value on a single rowHands-on Exercise: Calculate value on a single row using connected passivetransformation WORKING WITH SORTER, SEQUENCE GENERATOR, & FILTERTRANSFORMATIONDifferent types of transformations such as sorter, sequence generator, and filter, thecharacteristics of each, and where they are usedHands-on Exercise: Transform data using the filter technique, using a sequencegenerator, and using a sorterInformatica Certification Training7 Page
WORKING WITH JOINER TRANSFORMATIONWorking with joiner transformation to bring data from heterogeneous data sourcesHands-on Exercise: Use joiner transformation to bring data from heterogeneousdata sources WORKING WITH RANKING & UNION TRANSFORMATIONUnderstanding the ranking and union transformation and the characteristics anddeploymentHands-on Exercise: Perform ranking and union transformation SYNTAX FOR RANK & DENSE RANKLearn the rank and dense rank functions and the syntax of themHands-on Exercise: Perform rank and dense rank functions ROUTER TRANSFORMATIONUnderstanding how router transformation works and its key featuresHands-on Exercise: Perform router transformation SOURCE QUALIFIER TRANSFORMATION & MAPPINGSLookup transformation overview and different types of lookup transformations:connected, unconnected, dynamic, and staticHands-on Exercise: Perform lookup transformations: connected, unconnected,dynamic, and static SLOWLY CHANGING DIMENSION IN INFORMATICAWhat is SCD? Processing in Xml, learn how to handle a flat file, list and definevarious transformations, implement ‘for loop’ in PowerCenter, the concepts ofpushdown optimization and partitioning, constraint-based loading, and incrementalaggregationHands-on Exercise: Load data from a flat file, implement ‘for loop’ in PowerCenter,use pushdown optimization and partitioning, do constraint-based data loading anduse the incremental aggregation technique to aggregate dataInformatica Certification Training8 Page
MAPPLET & LOADING TO MULTIPLE DESIGNERSDifferent types of designers: Mapplet and Worklet, planning a target load, loading tomultiple targets, and linking propertyHands-on Exercise: Create a mapplet and a worklet, plan a target load, and loadmultiple targets PERFORMANCE TUNING IN INFORMATICAObjectives of performance tuning, defining performance tuning, and learning thesequence of tuningHands-on Exercise: Do performance tuning by following different techniques REPOSITORY MANAGERManaging repository, Repository Manager: the client tool, functionalities of previousversions, and important tasks in Repository ManagerHands-on Exercise: Manage tasks in Repository Manager BEST PRACTICES IN INFORMATICAUnderstanding and adopting best practices for managing repository WORKFLOW INFORMATICACommon tasks in workflow manager, creating dependencies, and the scope ofworkflow monitorHands-on Exercise: Create a workflow with the dependencies of nodes PARAMETERS & VARIABLESDefine the variable and parameter in Informatica, parameter files and their scope,the parameter of mapping, worklet and session parameters, workflow and servicevariables, and basic development errorsHands-on Exercise: Define variables and parameters in functions, use theparameter of mapping, use worklet and session parameters, and use workflow andservice variables ERROR HANDLING & RECOVERY IN INFORMATICAInformatica Certification Training9 Page
Session and workflow log, using debuggers, the error-handling framework inInformatica, and failover and high availability in InformaticaHands-on Exercise: Debug development errors, read workflow logs, and use theerror-handling framework HIGH AVAILABILITY & FAILOVER IN INFORMATICAConfigurations and mechanisms in recovery and checking the health of thePowerCenter environmentHands-on Exercise: Configure recovery options and check the health of thePowerCenter environment WORKING WITH DIFFERENT UTILITIES IN INFORMATICAUsing commands: infacmd, pmrep, and infasetup and the processing of a flat fileHands-on Exercise: Use commands: infacmd, pmrep, and infasetup FLAT FILE PROCESSING (ADVANCED TRANSFORMATIONS)Fixed length and delimited, expression transformations: sequence numbers anddynamic targeting using transaction controlHands-on Exercise: Perform expression transformations: sequence numbers anddynamic targeting using transaction control DYNAMIC TARGETINGDynamic target with the use of transaction control and indirect loadingHands-on Exercise: Use transaction control with dynamic target and indirectloading WORKING WITH JAVA TRANSFORMATIONSImportance of Java transformations to extend PowerCenter capabilities,transforming data, and active and passive modeHands-on Exercise: Use Java transformations to extend PowerCenter capabilities UNCONNECTED STORED PROCEDURE USAGEUnderstanding the unconnected stored procedure in Informatica, and differentscenarios of unconnected stored procedure usageInformatica Certification Training10 P a g e
Hands-on Exercise: Use the unconnected stored procedure in Informatica indifferent scenarios ADVANCED CONCEPTS IN SCDUsing SQL transformation (active and passive)Hands-on Exercise: Use SQL transformation (active and passive) INCREMENTAL DATA LOADING & AGGREGATIONUnderstanding incremental loading and aggregation and comparison between themHands-on Exercise: Do incremental loading and aggregation CONSTRAINT-BASED LOADINGWorking with database constraints using PowerCenter and understandingconstraint-based loading and the target load orderHands-on Exercise: Perform constraint-based loading in a given order XML TRANSFORMATION & ACTIVE LOOKUPVarious types of XML transformation in Informatica and configuring a lookup asactiveHands-on Exercise: Perform XML transformation and configure a lookup as active PROFILING IN POWERCENTERUnderstanding what data profiling in Informatica is and its significance in validatingcontent and ensuring quality and the structure of data as per business requirementsHands-on Exercise: Create data profiling in Informatica and validate the content WORKFLOW CREATION & DELETIONUnderstanding workflow as a group of instructions/commands for integrationservices and learning how to create and delete workflow in InformaticaHands-on Exercise: Create and delete workflow in Informatica DATABASE CONNECTIONUnderstanding the database connection, creating a new database connection inInformatica, and understanding various steps involvedInformatica Certification Training11 P a g e
Hands-on Exercise: Create a new database connection in Informatica RELATIONAL DATABASE TABLESWorking with relational database tables in Informatica and mapping for loading datafrom flat files to relational database filesHands-on Exercise: Create mapping for loading data from flat files to relationaldatabase files LINKEDIN CONNECTIONUnderstanding how to deploy PowerCenter for seamless LinkedIn connectivityHands-on Exercise: Deploy PowerCenter for seamless LinkedIn connectivity CONNECTION WITH SOURCESConnecting Informatica PowerCenter with various data sources like social mediachannels, such as Facebook, Twitter, etc.Hands-on Exercise: Connect Informatica PowerCenter with various data sourceslike social media channels, such as Facebook, Twitter, etc. PUSHDOWN OPTIMIZATION & PARTITIONINGPushdown optimization for load-balancing on the server for better performance andvarious types of partitioning for optimizing performanceHands-on Exercise: Optimize using pushdown technique for load-balancing on theserver for better performance and create various types of partitioning for optimizingperformance CACHE MANAGEMENTUnderstanding session cache, the importance of cache creation, implementingsession cache, and calculating cache requirementHands-on Exercise: Implement cache creation and work with session cacheInformatica Certification Training12 P a g e
Project WorkInformatica Projects CoveredAdmin ConsoleIn this project, you will be expected to carry out tasks such as the creation of users,building roles, forming groups, a collaboration of users, roles, and groups, lock handling,creating sessions, workflows, and worklets.Deploying Informatica ETL for Business IntelligenceIn this project, you will have to access data from multiple sources, manage current andhistoric data with SCD, import source and target tables, etc., and extract the data and fetchit into staging. It will have to be pushed to the operational data store to the enterprise datawarehouse and then will have to generate reports and insights.Deploying ETL Transactions on Healthcare DataHere, you have to systematically load data within a hospital scenario for easy access. Youwill be extracting data from multiple sources, cleansing the data, putting it in the rightformat, and loading the data into the CRDW. You will create CRDW load schedules thatare on daily, weekly, and monthly basis.Case Study 1 - Banking Products AugmentationThis case study is about improving the profits of a bank by customizing the products andadding new products based on customer needs. You will construct a multidimensionalmodel, deploy a star-join schema, create demographic mini-dimensions, and work withInformatica aggregator transformations.Case Study 2 - Employee Data IntegrationIn this case study, you will load a table with employee data using Informatica. You willcarry out tasks such as creating multiple shared tables, working with the plug-and-playcapability of the framework, and using code and framework reusability.Informatica Certification Training13 P a g e
CertificationAfter the completion of the course, you will get a certificate from Intellipaat.Informatica Certification Training14 P a g e
Success StoriesKevin K WadaThank you very much for your top-class service. A special mentionshould be made for your patience in listening to my queries and givingme a solution, which was exactly what I was looking for. I am giving youa 10 on 10!Sampson BasoahThe Intellipaat team helped me in selecting the perfect course that suitsmy profile. The whole course was practically oriented, and the trainerswere always ready to answer any question. I found this course to beimpactful. Thank you.Sugandha SinhaIntellipaat's course instructors were excellent and well-versed with theirconcepts. The support team solved all my queries within the pro
Hands-on Exercise: Load data from a flat file, implement ‘for loop’ in PowerCenter, . Define the variable and parameter in Informatica, parameter files and their scope, the parameter of mapping, worklet and session parameters, workflow and service variables, and basic development errors Hands-on Exercise: Define variables and parameters in functions, use the parameter of mapping, use .
