About Dwpeople:
Dwpeople was started by group of Data warehouse consultants who work in ETL industry and provide quality training in the field of Data warehousing specially in ETL tools like Informatica and Data stage.

About our Training:
We have the infrastructure to provide online training worldwide we have provided live instructor lead training online to students in UK, Australia and United States.

We can remotely configure your system so that you can practice the exercises on your laptops/desktop after each class. We use WEB-EX virtual class room for all online training programs.

We believe in training via hands on practical exercises only then one can master the tool rather than going thru pdf or ppt presentation

Placements:
We work with many Placement companies to place our students and these companies are very good at marketing and have a very good success rate in the field of Data warehousing.

Training Details:
Our training model is prepared by experienced consultants which will help any student to understand the concept and master it. To view our training model please click the below link http://dwpeople.webs.com/dummybusinessmodel.htm

Course content :

  • Overview on DWH
  • Overview on Informatica
  • Navigation In Informatica (practical session)
  • Create ODBC connections and Relational connection (practical session)
  • Importing sources and Targets (practical session)
  • Creating source tables in oracle for future exercises (10 tables) (practical session)
  • Parallel load, seq Load, worklet, conditional loading (link operator) (practical session)
  • Transformations in Informatica - (practical session)
  • Filter Transformation  (practical session)
  • Expression Transformation (practical session)
  • Parameter files (practical session)
  • Aggregator Transformation (practical session)
  • Router Transformation  (practical session)
  • File watch concept(event wait) (practical session)
  • Lookup Transformation (practical session)
  • Unconnected Lookup (practical session)
  • Rank Transformation (practical session)
  • Joiner Transformation (practical session)
  • Sequence Generator (practical session)
  • Pre-sql and post-sql  (practical session)
  • Using command task and email task. (practical session)
  • Sorter Transformation  (practical session)
  • Normalizer Transformation  (practical session)
  • Stored procedure transformation (practical session)
  • Update strategy (practical session)
  • SCD1 (practical session)
  • SCD2 (practical session)
  • SCD3 (practical session)
  • Build star schema (practical session)
  • Load Dimension tables and Fact table and generate Business Objects reports (practical session)
CV prep, Interview Prep, Real time Doc’s, Discusses 3 real time projects in real time to crack the interviews.
If you are interested to know more please contact
Sachin Amin
Certified Informatica Consultant
Sachin.amin@dwpeople.com
Blog: DWPEOPLE.WEBS.COM
Mob: 614-657-1706