Implementing SCD Using Designer Screen Wizards | Learning Informatica PowerCenter 10.x

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Learning Informatica PowerCenter 10.x - Second Edition

By : Rahul Malewar

4.3 (4)

Learning Informatica PowerCenter 10.x

4.3 (4)

By: Rahul Malewar

Overview of this book

Informatica PowerCenter is an industry-leading ETL tool, known for its accelerated data extraction, transformation, and data management strategies. This book will be your quick guide to exploring Informatica PowerCenter’s powerful features such as working on sources, targets, transformations, performance optimization, scheduling, deploying for processing, and managing your data at speed. First, you’ll learn how to install and configure tools. You will learn to implement various data warehouse and ETL concepts, and use PowerCenter 10.x components to build mappings, tasks, workflows, and so on. You will come across features such as transformations, SCD, XML processing, partitioning, constraint-based loading, Incremental aggregation, and many more. Moreover, you’ll also learn to deliver powerful visualizations for data profiling using the advanced monitoring dashboard functionality offered by the new version. Using data transformation technique, performance tuning, and the many new advanced features, this book will help you understand and process data for training or production purposes. The step-by-step approach and adoption of real-time scenarios will guide you through effectively accessing all core functionalities offered by Informatica PowerCenter version 10.x.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Free Chapter

Downloading and Extracting Informatica PowerCenter Software

Downloading and Extracting Informatica PowerCenter Software

Downloading the latest version of Informatica PowerCenter - 10.1.0

Extracting the downloaded files - preparing the installable

Informatica installation - the prerequisites

Beginning the installation - installing the server

Getting the graphical interface ready- client installation

Summary

Understanding Admin Console

Understanding Admin Console

The Informatica architecture

Informatica services

The Administration Console - configuration

Repository creation - the centralized database for Informatica

Creating the integration service - the path for flow of data

Model Repository Service - a storage place for other developer tools

Informatica users and authentications

Repository Manager - the client configuration

Summary

Understanding Designer Screen and its Components

Understanding Designer Screen and its Components

Understanding Designer Interface

Working with Sources

Working with Targets

Feel of data inside Repository - preview

Creating a Database Table

Creating a mapping and using transformation features

Summary

The Lifeline of Informatica - Transformations

The Lifeline of Informatica - Transformations

Creating the transformation

Expression transformation

Ports in transformations

Using the expression editor

Aggregator transformation

Sorter transformation

Filter transformation

Router transformation

Rank transformation

Sequence Generator transformation

Joiner transformation

Union transformation

Source Qualifier transformation

Classification of transformations

Lookup transformation

Update Strategy transformation

Normalizer transformation

Stored Procedure transformation

Transaction Control transformation

Types of Lookup cache

Tracing level

Summary

Using the Designer Screen - Advanced Features

Using the Designer Screen - Advanced Features

Debug me please - the debugger

Reuse me please - reusable transformation

Managing the constraints - the target load plan

Avoid hardcoding - parameters and variables

Comparing objects

Summary

Implementing SCD Using Designer Screen Wizards

Implementing SCD Using Designer Screen Wizards

Types of SCD

SCD1 - I hate history!

SCD2 (version number) - I need my ancestors!

SCD2 (flag) - flag the history

SCD2 (date range) - marking the dates

SCD3 - store something if not everything

Summary

Using the Workflow Manager Screen

Using the Workflow Manager Screen

Using the Workflow Manager

Creating a workflow

Adding a task to the workflow

Working with the Session task and basic properties

Assigning the integration service to the workflow

Deleting a workflow

Trigger - starting a workflow

Working with Connection objects

Summary

Learning Various Tasks in Workflow Manager screen

Learning Various Tasks in Workflow Manager screen

Working with tasks

Configuring a task

Session task

Command task

Email Task

Assignment Task

Timer task

Control task

Decision task

Event tasks - Event Wait and Event Raise

Link task

Worklets - Groups of tasks

Summary

Advanced Features of Workflow Manager Screen

Advanced Features of Workflow Manager Screen

Schedulers

File list - the indirect way

Incremental Aggregation

Parameter file - parameters and variables

Summary

Working with Workflow Monitor - Monitoring the code

Working with Workflow Monitor - Monitoring the code

Using the Workflow Monitor

Connecting the Workflow Manager Screen

Opening previous workflow runs

Running or recovering workflow or task

Stopping or aborting the workflow or task

Status of the workflow and tasks

Viewing session log and workflow log

Working with the workflow log

Working with the session Log

Viewing workflow run properties

Viewing session run properties

Common Errors

Summary

The Deployment Phase - Using Repository Manager

The Deployment Phase - Using Repository Manager

Using the Repository Manager

Take me to the next stage - Deployment or Migration

Summary

Optimization - Performance Tuning

Optimization - Performance Tuning

Bottlenecks

Working on partitioning

Pushdown optimization

Summary

SCD3 - store something if not everything

To implement SCD3 using wizard, please follow the steps mentioned here:

In the Designer, go to Tools | Mapping Designer | Mapping | Wizard | Slowly Changing Dimensions as shown in the following screenshot:

A new window will pop up asking the name (m_SCD3) of the new SCD mapping. Also select the type of SCD you wish to implement. Select Type 3 Dimension - keep the current and previous value in the target as we are implementing SCD3, and click on Next:

The next screen will ask you to select the source. Select a source from the drop-down. We are using EMP_FILE.txt as the source file for our reference. We will name the target EMPLOYEE_SCD3 for our reference in this book. Click on Next:

In the next window, select EMPLOYEE_ID as Logical Key Field. Also, add LOCATION under Fields to compare for changes, and click on Next:

In the next window, select the target columns you wish to compare to detect changes. In our case, the LOCATION column in the target will be...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learning Informatica PowerCenter 10.x

Search

Your notes and bookmarks