Why is Hibernate so popular? Because it automates a tedious task - persisting your Java objects to a relational database. If Hibernate makes ...
Informatica PowerCenter tutorial video
Informatica PowerCenter is an integration tool that supports all the steps of extraction, transformation and load (ETL) process. It is used in building enterprise data warehouses. Informatica has got visual interface so you just need to drag and drop different objects (transformations) and design dataflow.
The Informatica PewerCenter (version 9.5.1) video tutorial explain basic aspects of creating ETL process. It focuses on practical examples. Watch this course and learn Informatica PowerCenter in 2 h 6 min.
- Creating database (07:30)
Database schema, creating project folder
- Creating simple data flow (19:20)
Mapping, creating source definition, working with Source Analyzer, importing source from database, creating target definition, import target from database, creating simple mapping, creating workflow, executing workflow, workflow monitor
- Mapping (11:47)
Expression transformation, linking ports, mapping properties, propagating port attributes, importing and exporting objects
- Transformation overview: Source Qualifier, Expression, Filter, Router, Sorter (28:55)
Source Qualifier transformation properties, using Expression transformation, using Filter transformation, using Router transformation, using Sorter transformation
- Transformation overview: Joiner, Lookup, Aggregator, Rank, Stored procedure, Update Strategy (48:18)
using Joiner transformation, using Lookup transformation, using Aggregator, using Rank transformation, using Stored procedure transformation, using Update Strategy transformation
- Variables and Parameters (09:58)
Defining a variable in mapping level, defining a variable in workflow level, Assignment task, presession assignment, finding errors
Frequently Asked Questions
Watch sample lesson and see how fast and easy discovering new knowledge can be: