Informatica Beginner to Advanced

Sort data with an active transformation to illustrate ascending and descending orders, distinct records, case sensitivity, and sorting across multiple columns.

Explore expression transformation in Informatica, learn to distinguish passive and active transformations, apply conditional logic, and build robust mappings with variables, ports, and naming conventions.

Explore the filter transformation in Informatica, where an expression acts as a condition to pass matching records and drop others, with active versus passive behavior and and/or logic.

Explore router transformations, an active transformation that evaluates multiple conditions on incoming data and routes records to default or group targets, guided by mapping sessions.

Explore aggregator transformation in Informatica, an active transformation that performs group-based calculations (max, min, average) and returns the last record per group, with performance tips for sorted data.

Explore the joiner transformation as an active process linking two sources via a matching condition on one or more columns, supporting homogeneous or heterogeneous sources and master and detail relationships.

Explore source qualifier transformation in Informatica: join homogeneous sources, use custom queries and user-defined joins, and apply expression transformations for salary calculations and data prep.

Learn to implement a source qualifier transformation with joins, filters, sorts, and distinct operations in Informatica, including writing and executing queries and handling an invalid object in mappings.

Rank transformation in Informatica ranks data within groups to top or bottom values and handles ties with skipped sequences. Compare with analytic functions and learn practical grouping and output techniques.

Use the union transformation to merge data from multiple sources with matching columns into a single output. Deduplicate when needed with sort, rank, aggregator, or expression transformations.

The normalize transformation is an active step that normalizes records from Google and relational sources for legacy systems, adding a generated key and expanding single-column data into multiple rows.

Explore how the sequence generator creates unique primary values, increments by one, and maintains current and next values, including reusable sequences across sessions and multiple targets to ensure uniqueness.

Explore the lookup transformation in Informatica: understand static and dynamic, connected and unconnected, active and passive modes, and how caching and lookups optimize mapping performance for data enrichment.

Learn how to configure an active lookup transformation in a mapping, handle multiple-match behavior, and connect source and target data for department and language lookups within a workflow.

Explore four properties in the lkp transformation policy on multiple match and learn to create a new mapping, copy mappings, and configure active versus passive handling and use any value.

Learn to design an unconnected lookup in Informatica, configure the mapping on department_source, set joining conditions, and call the lookup via an expression transformation.

Discover dynamic lookup in Informatica, including cache maintenance, insert and update handling, and no-change versus new records using serial number based joining.

Explore update strategy transformation in Informatica, learning how insert, update, delete, and reject rules change data flow under conditions, with data-driven updates and two-level mapping.

Explore updating the target without an update strategy by configuring mapping and session properties for insert, update, delete, update as insert, and truncate in a source-to-target workflow.

Learn how the transaction control transformation in Informatica decides per record to commit, rollback, or continue writing using conditional logic in the expression editor.

Demonstrates practical Informatica mapping design: define source and target, rename fields, add a filename column, implement sorting and condition expressions, and validate a session workflow.

Check in and check out Informatica objects, recover deleted sources, and manage mappings using repository tools. Document changes with dev docs, audit trails, and mapping checklists to support reproducible development.

connect to repositories, configure the repository manager, and import xml data by designing mappings and workflows to load scenarios into target tables.

Explore how to parameterize Informatica mappings with mapping parameters and mapping variables using a parameter file, covering global and local scopes, initial values, and execution order.

Master incremental load and change data capture (CDC) in Informatica, including initial and full loads, mapping variables, source qualifiers, and transformations to capture new or changed records.

Explore how to define a target load order within a mapping pipeline for the integration service, deciding which target loads first by sequencing source qualified transformations and targets.

Demonstrate constraint based load by loading data from the source to the primary table and then to the chain table via staging, using mapping and workflow concepts.

Explore mapplets as reusable sets of transformations that simplify mappings, enable consistent salary calculations, and support building scalable, maintainable data integration workflows in Informatica.

Explore how to use command prompts to manage Informatica workflows, sessions, and mappings, including configuring sources and targets, triggering dependent workflows, and monitoring execution status.

Configure Informatica workflows to automate email tasks, route decisions by session status, and craft alerts to support and business teams using naming conventions and email formatting.

Explore how to raise and wait for events, define expressions and transformations, manage dependencies and conditions, and monitor workflows to auto-trigger tasks in Informatica.

Explore Informatica session properties, including stop on errors, conflict handling, and bulk versus normal loads, to control data routing and workflow execution.

Discover how push down optimization shifts transformation logic to the source or target database to improve mapping performance, including what can be pushed into select statements and common limits.

Explore slowly changing dimensions type 1, maintaining current data by inserting or updating records via lookups and expression transformations, including name concatenation, phone formatting, and salary calculation in Informatica.

Explore SCD 2 approaches to maintain history, including the method, flag, and Wardian method, and apply current date flags with surrogate keys.

Learn how to implement type 2 slowly changing dimension to preserve history and current records using lookups, expression transformations, and insert-update strategies in Informatica.

Explore change data capture using checksum and md5-based verification to detect source-to-target changes, and design a mapping with lookup, join, and modified function transformations in Informatica.

Explore SCD 3 maintenance by tracking the last three customer addresses, using lookups, expression transformations, and a reusable transformation to capture current and previous addresses.

Explore a dummy screening project, learn to interpret documents, and design staging, mappings, and auditable workflows in Informatica with data validation, cleansing, and lookups.