1 / 10

Informatica online training | Online Informatica Training in

Smart mind Online Training is spent significant time in giving online classes to online Informatica preparing, online Teradata training,online hadoop preparing and Data Warehousing, Informatica and Teradata with Real Time by masters in the business. Smart mind Online Training gives particular Computer courses, which has sufficient of chances in present programming industry and backings the learners to advance their insight with exceptional data. Online Informatica Training additionally offers them quality rules to enhance their insight. We gives the Training to the learners in diverse ideas and modes to be the basic in the present place of employment business sector, having quality, skilled and current Industry master workforce. Furthermore gives preparing on complete undertaking (END TO END) with ongoing. Online Informatica Training likewise enhances the trainees in all the ranges and particularly at cutting edge ideas. <a href=” http://www.leadonlinetraining.com/informatica-onlinetraining/”> Informatica Online training </a>

janiceellis
Download Presentation

Informatica online training | Online Informatica Training in

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.

E N D

Presentation Transcript


  1. Informatica online training

  2. Informatica Online Training • Informatica Online Training Course Content : • Data Warehousing Concepts • Dataware housing (what is Dataware housing /Why Dataware housing/How Dataware housing)•    Slowly Changing Dimensions (SCD1, SCD2, SCD3)•    Metadata•    Dimentinal Table•    Types Of Dim Tables•    Fact Table•    Types of Fact Tables

  3. OLTP (OnLine Transaction Processing)•    OLAP (Online Analysis And Processing)•    OLTP Vs OLAP•    Advantages of OLAP•    Different Methodologies of DWH • PowerCenter Components and User Interface • Informatica PowerCenter Architecture•    Informatica PowerCenter Client Tools•    Start Using of the Designer, Workflow Manager and Workflow Monitor

  4. Source Qualifier • •    Source Qualifier Transformation•    SQL override in source qualifier transformation•    Source qualifier transformation joins concept•    Source qualifier transformation on RelationalDatabases•    Source qualifier transformation on File systems•    Source qualifier transformation filter concepts•    DifferenceBetween SQL Override, Other Options

  5. Source Qualifier Transformation Performance Tunning•    Pre SQL and Post in Source Qualifier Transformation • Expression, Filter, File Lists and Workflow Scheduler • Expression Editor•    Filter Transformation•    File Lists•    Workflow Scheduler•    Lab – Load the Customer Staging Table and Real time issues

  6. Joins, Features and Techniques I • Joiner Transformation•    Shortcuts•    Lab A – Load Sales Transaction Staging Table•    Lab B – Features and Techniques I and Real time issues • Lookups and Reusable Transformations • Lookup Transformation•    Reusable Transformations•    Lab A – Load Employee Staging Table•    Lab B – Load Date Staging Table and Real time issues

  7. Debugger • •    Debugging Mappings•    Lab – Using the Debugger • Sequence Generator • •    Sequence Generator Transformation•    Lab – Load Date Dimension Table and Real time issues

  8. Lookup Caching, More Features and Techniques • •    Lookup Caching•    Lab A – Load Promotions Dimension Table•    Lab B – Features and Techniques II•    Review and more Lab Activities and Real time issues • Router, update Strategy and Overrides • •    Router Transformation•    Update Strategy Transformation•    Expression Default Values

  9. Informatica online training Smart Mind Online Training is one of the top online training institutions in India we are providing online trainings according to the student convenient time and requirements by +5 real time experienced faculty who are working in top MNC’s and also providing 24*7 technical support. • Contact us: • India:+91 9949599844 • USA:+1-347-606-2716 • E-mail:contact@smartmindonlinetraining.com

  10. THANK YOU

More Related