Informatica Tutorial - Informatica Online Training

Explore the ETL process: extract, transform, and load data into a data warehouse or data mart. Learn about staging areas, data validation, cleansing, and transformations that ensure accurate, analysis-ready data.

Explore major etl tools in the market, compare selection criteria such as performance, data quality, usability, and connectivity, and see Informatica among the dominant options.

Understand data transformations in a warehouse: data mapping, transformation rules, and tasks like surrogate keys, lookups, one-to-many and many-to-one transformations, and slowly changing dimensions to load into the target.

Explore the main data transformations used in staging areas: data cleansing, scrubbing, aggregation, and merging, and learn how they ensure data integrity before final load.

Explore the Informatica power center components. Learn its ETL capabilities, including expression transformation, router transformation, aggregator, look up, and joiner, to load data into a warehouse.

Explore power center designer, an etl tool for extracting data from sources, applying transformations, and loading into targets via mappings, transformations, and map designer.

Create and execute Informatica mappings with the workflow manager, building sessions, linking them in series or parallel, and delivering an executable ETL workflow for target tables.

Use the Informatica workflow monitor to view workflow and task status with a Gantt chart, track dependencies, and monitor parallel or serial execution; access logs and historical data for debugging.

Explore the Informatica repository manager, a relational database that stores metadata, user credentials, permissions, and groups, and learn to organize metadata with folders, manage users, and configure folder access.

Access the admin console to manage Informatica PowerCenter domains, services, nodes, licenses, and security. Configure properties, folders, and permissions to control domain objects, view events, and monitor resources.

Explain the Informatica power center client–server architecture. Identify four tools—designer, repository manager, workflow monitor, workflow manager—and describe how deployment moves from development to production.

Explore Informatica’s service oriented architecture, focusing on repository and integration services to manage source definitions, transformations, and loading into the repository database via native drivers or ODBC connections.

Understand how the domain anchors Informatica's service oriented architecture, supports installation with metadata tables, and enables high availability via primary and secondary nodes and the opposite service.

Install and configure Informatica PowerCenter 9.6.1 on server and client, outlining prerequisites such as Oracle 11g and database setup, plus hardware and software system requirements.

Learn how to use a prebuilt VM in part 1 of the Informatica online training, with setup steps and a practical walkthrough.

Learn how to use a prebuilt VM in Informatica online training, part 2, and align with the course's instructions.

Explore the types of sources and targets Informatica PowerCenter supports, including RDBMS and flat files, and learn how to configure flat-file processing and data type handling.

This lecture explains how to use the Informatica target designer: connect to a database, import target definitions, and explore the departmental table with its columns, data types, and primary key.

Create a mapping to load a source table to a flat file target, using a bar delimiter and the mapping designer to set up a one-to-one transfer.

Create a mapping to load data from a flat file source into a target table by importing the source, importing the target, and establishing a one-to-one mapping in the designer.

Enable the fail parent if task fails to stop the complete workflow when a session fails, and monitor session logs to diagnose issues on the target table.

Enable backward compatibility session log files in Informatica to write logs as text, and locate them in the server SAS logs directory; binary logs appear by default if not checked.

Bulk load speeds large data transfers by bypassing the database log but cannot rollback; drop and recreate indexes around it, while normal load uses indexes and supports recovery.

Use pre and post SQL in Informatica workflows to drop indexes on the target table before loading, then recreate them after. Check session logs to verify the changes.

Describe the stop on errors session property, its default zero, and why setting it to one helps catch duplicates and stop on the first error to protect data loads.