Informatica Online Training Course and Help

  • Updated
  • Posted in Programming
  • 2 mins read

We present free informatica on-line coaching in informatica growth which entails utilizing the informatica mapping designer, workflow supervisor. We will assist or help you within the following listed subjects.

Informatica Online Training

Mapping designer Topics

  • Analyzing and creating the Sources, Targets (solely flat recordsdata and oracle relational database)
  • Importing the sources and Target tables.
  • Creating a Pass-Through Mapping
  • Creating a Mappings, mapplets, Transformations.

Various Transformations Covered

  • Active and passive transformations
  • Source qualifier Transformation
  • Aggregator Transformation
  • Expression Transformation
  • Lookup Transformation
  • Filter Transformation
  • Sequence Generator Transformation
  • Stored Procedure Transformation
  • Expression Transformation
  • Router Transformation
  • Sorter Transformation
  • Rank Transformation
  • Joiner Transformation
  • Update technique Transformation
  • Transaction management Transformation
  • Union Transformation
  • Normalizer Transformation
  • Sql transformation.

Advanced or Misc Topics in Mapping Designer

  • Creating Slowly altering dimensions (SCD) utilizing the mapping wizard.
  • Creating SCD Type 1, Type 2 and Type 3 with out utilizing the mapping wizard
  • Specifying the goal load order and saved process execution order.
  • Creating shortcuts and copying objects.

Workflow supervisor Topics

  • Creating Sessions, duties, worklets and Workflows
  • Configuring Database Connections within the Workflow Manager
  • Creating a Reusable Session
  • Creating a Workflow
  • Running and Monitoring Workflows
  • Opening the Workflow Monitor

Workflow Tasks lined are

  • Session
  • Assignment activity
  • Event elevate activity
  • Event wait activity
  • Timer activity
  • Email activity
  • Command activity

Miscellaneous subjects

  • Post session and Pre-session instructions
  • Pre sql and put up sql
  • Session restoration
  • Commit factors
  • Creation of Parameter file
  • Mapping and session parameter
  • Constraint primarily based loading
  • Pushdown optimization
  • Incremental aggregation
  • Incremental load and full load.
  • Normal and bulk load.

If you will have any issues or logic have to be solved in informatica, please drop an e-mail at [email protected] with clear description of your drawback, supply enter and how goal output ought to appear to be. I might be out there on-line from 7PM to 8PM IST.

Note: Right now i’m offering coaching by way of gmail chat solely. You have to have informatica put in in your PC. I’ll replace right here concerning the full-fledged coaching.

Leave a Reply