CALL NOW! 17328234456

Data Warehousing - Informatica

  • Informatica, Teradata, Netezza

1. Introduction to Data warehousing

  • Overview of a OLTP/Transactional system
  • Forms of Normalization
  • Pros/Cons of having an OLTP system in real time reporting.
  • Need of a data warehouse.
  • Data warehouse layer architecture.
  • Designing a warehouse using Star/Snowflake schemas.
  • Logical/Physical Models in Erwin

2. Informatica Designer

  • Basic Concepts
  • Using the designer.
  • Working with the Sources-Source Analyzer
  • Working with Relational
  • Flat file targets- Warehouse Designer.
  • Defining Keys in Informatica.
  • Working with Transformations –Transformation Developer
  • Working with Mapplets- Mapplet designer.
  • Creating mappings –Mapping Designer.
  • Understanding Pipelines in mappings.
  • Configuring Constraint Based loading.
  • Introduction to Mapping Parameters/Variables.
  • Implementing Type1, Type2, and Type3 Mappings.
  • Loading Fact tables.

3. Working with Transformations

  • Active/Passive Transformations
  • Caching concepts in Informatica.
  • Connected/Unconnected Transformation
  • Filter, Router
  • Expression,Sorter,Aggregator,Rank,Joiner,Lookup
  • Stored Procedure
  • Sequence generator
  • Union
  • Transaction Control
  • Update Strategy
  • Xml transformation
  • Normalizer

4. Creating Workflows

  • Understanding the server Architecture
  • Working with Workflows
  • Working with Tasks Assignment,Command,Decision,Control,Event raise,
  • Event Wait,Timer,Email,Session Task
  • Working with Work lets
  • Working with Sessions
  • Understanding Commit Points
  • Recovering Data
  • Monitoring Work flows
  • Log files
  • Row Error Logging
  • Session parameters
  • Parameter files,Using Incremental Aggregation

5. Real-Time Implementation with Informatica

  • Performance Tuning(With Real time Examples).
  • Using Incremental Aggregation
  • Change Data capture concepts.
  • Session parameters and variables.
  • Session and Workflow properties Reference.
  • Pipeline partitioning.
  • Configuring Session caches lookup, Aggregate, Sort, Joiner caches.
  • Restart able Tables.
  • Reject Capture and Reprocessing.
  • Handling Soft\Hard Rejects.
  • Loading issues with respect to sources, targets, mappings, sessions, networks.
  • Session parameters
  • Parameter files,Using Incremental Aggregation

6.Introduction to SQL constructs

  • Review of Basic SQL statements
  • Select, Project, Join
  • Restricting row returns
  • Joining Oracle tables
  • Equi-join,Outer join
  • Hiding joins by creating views
  • Subqueries
  • Exercise – write a subquery
  • Correlated subquery
  • Non-correlated subqueries
  • Advanced SQL operators,Between operator,IN and NOT In operators
  • EXISTS clause
  • Using wildcards in queries (LIKEoperator)
  • Aggregation in SQL
  • Count(*),Sum,Avg,Min and max
  • Using the group by clause
  • Introduction to Oracle Database
  • Oracle Architecture
  • Create, Truncate, Drop Oracle tables
  • Insert, Update, Delete data in tables
  • Loading Oracle tables
  • Introduction to Netezza Database
  • Netezza Architecture
  • Create, Truncate, Drop Netezza tables
  • Insert, Update, Delete data in tables
  • Loading Netezza tables
  • Comparision between Oracle and Netezza

7.Unix

  • Basic Unix commands
  • Creating Parameter files
  • Running Informatica jobs from Unix
  • Checking logs

Training Schedule:

  • Start Date:Coming Soon
  • Training duration:4-5 weeks
  • Training Timings: Weekdays 6 to 8 AM (IST) 4 to 5 hours during Weekends.
Contact Us

Benefits:

  • Minimum starting salary of around $ 65 to $ 90 per hour
  • Attractive percentage basis
  • H1 filing for qualified candidates
  • Real time scenarios and lab sessions
  • E-verified company to provide OPT (STEM Extension)
  • Mock interviews, FAQs and interview questioners.
  • Resume preparation and mentoring based on the experience.
  • Medical/insurance and all other benefits
  • Preparation for the interviews.
  • Accommodation facility.