Professional Informatica Power Center ETL Course

Explore the Informatica power center walkthrough, mastering repository manager, designer, workflow manager, and workflow monitor to build etl mappings with sources and targets in Oracle databases.

Organizations accumulate 25 years of heterogeneous data from databases, XML, text, and Excel in separate sources, and a centralized solution enables unified analysis for OLTP and OLAP-driven decision making.

Explore data warehouse concepts, including historic versus current data with status flags, subject-oriented integrated time-variant nonvolatile storage, design approaches, and etl steps from data mapping to archival backups.

Create and import sources and targets in Informatica, then design a mapping to extract data from a source and load it into a target, and run via the workflow manager.

Create sources and targets from databases, design a mapping with a source qualifier in the mapping designer, then validate and run a workflow, monitoring its execution.

Explains the source qualifier transformation in Informatica PowerCenter, including linking ports, validating mappings, and using sort and distinct options with pre and post session steps.

Explore how to design a mapping with a source qualifier transformation in Informatica PowerCenter, linking sessions in sequence or parallel, configuring file readers and targets, and troubleshooting data conversion issues.

Explore the filter transformation in Informatica PowerCenter ETL to filter unwanted records and apply conditions, with sorting using the sort transformation.

Explore the sorter transformation in Informatica Power Center, apply distinct to remove duplicates, and examine when the source qualifier behaves as an active or passive transformation.

Master the aggregator transformation in Informatica power center to compute max salary per department by grouping records. Learn how ports, expressions, and duplicate handling work together, including nested aggregate constraints.

Learn how to optimize the aggregator transformation by pre-sorting data before grouping to compute max salary by department, and explore the sequence generator for creating sequential values.

Learn how to remove duplicates in Informatica PowerCenter using sorter and aggregator, handling duplicates on the employee number with count, and routing via a router transformation to a separate target.

Learn to use the router transformation to route a single input to multiple department targets, create groups and a default group, and manage duplicates with aggregator or expression transformation.

Explore the rank transformation in Informatica, ranking employees by salary and comparing normal rank with dense rank, including top or bottom options to generate specific ranks.

Learn how the union transformation merges multiple inputs into one output, enforces identical structure, and distinguishes union from union all, including duplicate handling with sort and distinct.

Learn expression transformation in Informatica PowerCenter ETL to format input, validate data, trim spaces, and create fullName by concatenating first and last names, plus data conversions and ranking capabilities.

Explore expression transformation in Informatica to concatenate first and last names with spaces, handle nulls with if-else, and route valid versus invalid records using a router and mapping workflow.

Master expression transformation concepts in Informatica PowerCenter ETL by linking ports by name or position, routing valid and invalid records, and applying trimming, defaults, and validation logic.

Learn advanced expression transformation techniques, including final salary calculation with salary plus commission, and using decode or nested if for grade logic.

Explore expression transformation in Informatica PowerCenter ETL, including mapping impact from source/target changes, dependency-based impact analysis, and using built-in variables for auditing and sequence generation.

Learn how to generate sequences in Informatica without the sequence generator by using an expression transformation, including port types, variable handling, and the ordering of ports for correct sequencing.

Master expression transformation in Informatica Power Center, covering port assignment, sequence generation, date conversions with to_date and to_char, and rank techniques using sort and expression transformation.

Demonstrate building a rank-like logic in an expression transformation using variable ports and previous salary checks, and illustrate duplicate removal with distinct, sort, and aggregator.

Learn to remove duplicates using expression transformation, sorting by employee number, and a running count, then route valid and invalid records to separate targets with flag files.

Learn joiner transformation concepts and types (inner, left outer, right outer, full), join conditions, and how Informatica overcomes Oracle join limits by combining multiple sources.

Learn to use the joiner transformation to join two sources, define master and detail, set join conditions, and choose inner, left, right, or full outer joins for efficient etl.

Learn the Informatica joiner transformation and its four join types, with hands-on practice to join two or more sources. Discover performance tips, including sorted input and master-source strategies.

Explore the transaction control transformation to dynamically create flat file targets by department, overcoming router limitations. Learn how to generate targets for departments 10, 20, and 30 with dynamic scaling.

This lecture extends transaction control concepts, explaining continual and before/after behaviors, how DC commands begin or commit transactions, and how flags route records to new or existing transactions.

Learn to dynamically create multiple target files with transaction control in Informatica PowerCenter, naming outputs via expressions and sequence generators, and control commit behavior with before or after options.

Explore the normalize transformation to convert rows into columns, create input and output ports, and generate duplicates with the occurs setting, including generated key, sequence, and column ports.

Learn how to implement the normalizer transformation in Informatica PowerCenter, using expression, aggregator, and filter transformations to convert columns to rows (and vice versa), build mappings, and validate results.

Explore how to use the stored procedure transformation in Informatica PowerCenter, including connected and unconnected modes, input/output parameters, and calling procedures via expression transformations and procedure plans.

Explore using the SQL transformation in Informatica PowerCenter to run SQL within a mapping, join employee and department data, and output department name and location.

Explore the update strategy transformation, which flags incoming rows for insert, update, or delete and requires a primary key on the target for proper operation.