Over View

[ezcol_1half]

The course teaches the fundamental and advanced concepts of Informatica PowerCenter 10 through online training including numerous hands-on lab exercises and real time scenarios. Students will gain a clear understanding of the product and acquire the solid foundation needed to make them efficient PowerCenter developers.

Prerequisites: SQL Basics

Objectives                                                                                                                         

  • Understanding the concepts of Data Warehousing.
  • Ability to design and develop complex mappings
  • Configuring Workflows as in real time environment
  • Troubleshooting errors/failures
  • Gain hands-on experience with multiple exercises and various real time scenarios and a Demo Project
  • Build confidence to excel your career as an efficient Informatica Developer/Consultant

[/ezcol_1half]

[ezcol_1half_end]

[/ezcol_1half_end]

Informatica Course Content

Module #1         

Overview of Data Warehousing

  • * Introduction to Data warehouse (What/Why/How
  • * Star schema/Snowflake schema/Galaxy schema
  • * Dimensions/Facts tables.
  • * Slowly Changing Dimensions and its types.                                                                                                                                                                                                                                                       

Module #2         

Basic ETL

  • Introduction to Informatica PowerCenter
  • (E)xtraction, (T)ransformation and (L)oading Process
  • PowerCenter Tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor)
  • Source and Target Object Definitions
  • Transformation Concepts (Types, Classifications, Basic uses)
  • ODBC & Relational Connections
  • Working with Flatfiles
  • Working with XML Files

Transformations:

  1. Filter
  2. Router
  3. Sequence Generator
  4. Rank
  5. Sorter
  6. Joiner
  7. Union
  8. Source Qualifier
  9. Expression
  10. Aggregator
  11. Lookup (Connected/Unconnected)
  12. Normalizer
  13. Stored Procedure (Connected/Unconnected)
  14. Update Strategy
  15. Transaction Control
  16. Java Transformation
  17. SQL Transformation (Query/Script)
  18. XML Parser
  19. XML Generator

Module #3         

Advanced ETL                                                                                                                                   

  • Different Load Types
  • Slowly Changing Dimensions (Type – 1/2/3)
  • Indirect Method for Loading
  • Mapplets and Reusable Transformations
  • Parameters and Variables (Mapping and Workflow)
  • Different Types of Tasks:
  1. Session
  2. Email
  3. Command
  4. Assignment
  5. Control
  6. Timer
  7. Decision
  8. Event Wait
  9. Event Raise
  • Working with Links
  • Worklets
  • Scheduler
  • Parallel and Serial Batching.
  • User Defined Functions
  • Incremental Aggregation
  • Constraint Based Loading
  • Target Load Plan
  • Performance Tuning
  • Pushdown Optimization
  • Wizards
  • Partitioning
  • Debugger

FAQ’S

What if I miss one (or) more class?

No need to worry about the classes you missed. We will definitely guide you by having optional classes or by having classes with other batches with the same topic you missed previous classes.

Who is my instructor?

IT professionals who have strong knowledge in technical know how to convey things with the real-time example. Even a layman could understand the concepts which given by our experts.

What are the modes of training offered for this course?

We offer this course in “Live Instructor-Led Online Training” mode. Through this way you won’t mess anything in your real-life schedule. You will be shared with live meeting access while your session starts.

What are the system requirements to work?

Minimum 2GB RAM and i3 processor is required

Can I attend a demo session?

You can get a sample class recording to ensure you are in right place. We ensure you will be getting complete worth of your money by assigning a best instructor in that technology.

How about group discounts (or) corporate training for our team?

We are absolutely loved to talk in-person about group training (or) corporate training. So, please get in touch with our team through “Quick Enquiry”, “Live Chat” or “Request Call-back” channels.

Where do Our Online learners and Trainer’s come from

We are providing online training, One-to-One training with the help of experts. Our learners and trainers are frequently coming from different countries like USA, India, UK, Australia, New Zealand, Canada and UAE. To specify in cities London, Bangalore, California, New York, Pune, Mumbai, Chennai, New Delhi, San Francisco, New Jersey, Texas, Florida, Kolkata, Gurgaon, Berlin and Hyderabad among many.

I have more queries?

If you want to know More Details about Online Training Please Contact us. Or you can share your quires through info@monstercourses.com. Estimated turnaround time will be 24 hours for mails.

Contact us

Enquiry Now..!!

Contact Details :

    Address: # 4110 Rainy Creek Ln, Cedar Park, TX, 78613, USA.

    Contact us: +1(772)777-1557

    Email ID: info@monstercourses.com

     

    Popular Courses We Offered :

     

    4110 Rainy Creek Ln, Cedar Park,

    TX USA, 78613.

    Phone: +1(772)777-1557

    Email : info@monstercourses.com

     

    The Training Classes what i have attended from MonsterCourses was quite beneficial.Good way of diving modules and covering important topics in each module. Overall the training from MonsterCourses was very good and useful to me.

    Vijay Naresh…

    Raju K, Monster Courses

    I felt OBIEE online training was very informative as compared to other online training providers. The faculty of MonsterCourses are very efficient in their subject and gave quality training. They covered each and every topic clearly elaborated them with examples.

    Vinay K…

    Govardhan Bhaskar, Monster Courses

    We are very much benefited from Business objects online training program. Handouts are very useful and very nicely given so that at-least by seeing the handouts we can practice and get knowledge. We have been taught many topics from this Training, nice to getting trained from “MonsterCourses

    Govardhan Bhaskar….

    Vijay Naresh, Monster Courses