Informatica PowerCenter – Developer basics

The two-day training provides knowledge of software development using Informatica PowerCenter.

Course objectives

Learning the basics of ETL based on the Informatica PowerCenter platform. Upon training completion, the participant can implement a complete ETL proces.

Benefits

Workshop participants will learn about:
- ETL basics
- The concept of dimensions, measures and facts
- Schemes: star, snowflake, constellation, starflake
- Informatica PowerCenter platform and tools included in it
- Creating and managing ETL processes
- Transformations
- Sequences
- Lookup
- Combining data from different sources
- Routing
- Parameters and their impact on process optimization
- Data update strategies and their selection
- Data Aggregations

Training scope

ETL basics
Overview of the Informatica PowerCenter platform
Selection of source and target data
Transformations, mappings, maplets
Sharing and reusability
Data Linking
Conditions
Functionalities and techniques
Sequences
Lookup
Caching
Strategies for updating, separating and overwriting data
Sorting, aggregations, variables / parameters and mapplets

Audience

All individuals involved in software development process using Informatica PowerCenter. Developers, testers and people who want to explore the platform and create an ETL process for the needs of data warehouses, thematic warehouses and aggregated data sets for reporting systems.

Course objectives

Learning the basics of ETL based on the Informatica PowerCenter platform. Upon training completion, the participant can implement a complete ETL proces.

Benefits

Workshop participants will learn about:
- ETL basics
- The concept of dimensions, measures and facts
- Schemes: star, snowflake, constellation, starflake
- Informatica PowerCenter platform and tools included in it
- Creating and managing ETL processes
- Transformations
- Sequences
- Lookup
- Combining data from different sources
- Routing
- Parameters and their impact on process optimization
- Data update strategies and their selection
- Data Aggregations

Training scope

ETL basics
Overview of the Informatica PowerCenter platform
Selection of source and target data
Transformations, mappings, maplets
Sharing and reusability
Data Linking
Conditions
Functionalities and techniques
Sequences
Lookup
Caching
Strategies for updating, separating and overwriting data
Sorting, aggregations, variables / parameters and mapplets

Audience

The number of participants: 8-15 people

Duration: 2 days

Available language: PL / EN

Available course material: PL / EN

Course form

Presentation, lecture, workshop, discussion.

Download materials

Download

First name*

Surname*

E-mail*

I consent to the processing of my personal data by Sii sp. z o.o. and its subsidiaries for the purpose of sending marketing information to the provided e-mail address.

At any time, you may withdraw your consent to the processing of personal data, but such withdrawal shall not affect the legal compliance of any processing of such data, which had occurred before you withdrew your consent. Detailed information on the processing of your personal data is specified in the Privacy Policy.

Thank You!

Sorry, something went wrong.

Please refresh the page and try again.

File upload error

No file was uploaded

Incorrect file size (max 5MB)

Invalid file format

Empty file

Processing...

Download materials

Download

Contact our experts with questions about any of our trainings

Natalia & Agata

Training Practice Team

Contact our experts

Natalia & Agata

First name*

Surname*

E-mail*

Phone number

Company name

Job position

Your message*

Your file

Uploaded file:

danieltroc.pdf

Allowed extensions: DOC, DOCX, PDF (max 5MB)

I consent to the processing of my personal data by Sii sp. z o.o. and its subsidiaries for the purpose of sending marketing information to the provided e-mail address. I consent to the processing of my personal data by Sii sp. z o.o. and its subsidiaries for recruitment purposes.

Development of a new product lifecycle management system

Ingenico Axis Roadmap Team

Software for real-time DNA image analysis

Improvement of test automation by DMI Robot

Sii Sweden

Sii Ukraine

Sii Poland is the largest IT services provider in Poland according to the ITwiz Best100 report for 2023

Get ready for the Get Digital Summit 2024! Register now and take your technology knowledge to the next level.

Digital Health and Care and Regulatory Affairs. Learn how to effectively connect health and business for the benefit of patients

The closer we are to those in need, the more we want to help – discover how Michał, Test and Analysis Engineer at Sii, used his problem-solving skills to help effectively

Performance Engineering Meetup

Design your IoT device with cybersecurity in mind. Regulations, challenges, solutions

Get Digital Summit

How to achieve business agility? SAFe success patterns and real-world case studies

What did the internship at Sii's Engineering Competency Center give me?

SAP MM – basic configuration process and new organization units within existing organization

Adobe Edge Delivery Services – easy creation of ultra-fast pages

Using structures as composite keys in C# dictionaries

Informatica PowerCenter – Developer basics

Course objectives

Benefits

Training scope

Audience

Download materials