3. Implementing SCD – Using Designer Screen Wizards | Learning Informatica PowerCenter 9.x

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Learning Informatica PowerCenter 9.x

By : Rahul Malewar

4 (10)

Learning Informatica PowerCenter 9.x

4 (10)

By: Rahul Malewar

Overview of this book

If you wish to deploy Informatica in enterprise environments and make a career in data warehousing, then this book is for you. Whether you are a developer who's new to Informatica or an experienced professional, you will learn all the features of Informatica. Basic knowledge of programming and data warehouse concepts is essential.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Starting the Development Phase – Using the Designer Screen Basics

1. Starting the Development Phase – Using the Designer Screen Basics

Informatica PowerCenter Designer

The Designer screen's components

Summary

2. Using the Designer Screen – Advanced

2. Using the Designer Screen – Advanced

Debug me please – the debugger

Reuse me please – reusable transformation

Managing constraints – the target load plan

I hate hardcoding – parameters and variables

Comparing objects

Summary

3. Implementing SCD – Using Designer Screen Wizards

3. Implementing SCD – Using Designer Screen Wizards

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

4. Finishing the Development – Using the Workflow Manager Screen Basics

4. Finishing the Development – Using the Workflow Manager Screen Basics

Using Workflow Manager

Creating a workflow

Adding tasks in a workflow

Working with the session task – basic properties

Connecting the tasks – links

Assigning Integration Service to a workflow

Deleting a workflow

Trigger – starting a workflow

Working with connection objects

Summary

5. Using the Workflow Manager Screen – Advanced

5. Using the Workflow Manager Screen – Advanced

Working with tasks

Configuring a task

The session task

The command task

The e-mail task

The assignment task

The timer task

The control task

The decision task

Event tasks – event wait and event raise

The link task

Worklets – groups of tasks

Schedulers

File List – the indirect way

Incremental aggregation

The parameter file – parameters and variables

Summary

6. Monitoring Your Code – Using the Workflow Monitor Screen

6. Monitoring Your Code – Using the Workflow Monitor Screen

Using Workflow Monitor

Connecting to the Workflow Manager screen

Opening previous workflow runs

Running or recovering workflows or tasks

Stopping or aborting the workflow or task

The status of workflows and tasks

Viewing the 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

7. The Lifeline of Informatica – Transformations

7. The Lifeline of Informatica – Transformations

Creating the transformation

The Expression transformation

Ports in transformations

Using the expression editor

The Aggregator transformation

The Sorter transformation

The Filter transformation

The Router transformation

The Rank transformation

The Sequence Generator transformation

The Joiner transformation

Union transformation

Source Qualifier transformation

Classification of transformations

The Lookup transformation

The Update Strategy transformation

The Normalizer transformation

The Stored Procedure transformation

Transaction Control transformations

Types of lookup cache

Tracing levels

Summary

8. The Deployment Phase – Using Repository Manager

8. The Deployment Phase – Using Repository Manager

Using Repository Manager

Configuring the client tools

Take me to next stage – deployment or migration

Summary

9. Optimization – Performance Tuning

9. Optimization – Performance Tuning

Bottlenecks

Working on partitioning

Pushdown optimization

Summary

A. Installing Informatica and Using Informatica Administration Console

A. Installing Informatica and Using Informatica Administration Console

The Informatica architecture

Informatica installation – the prerequisites

Downloading the Informatica PowerCenter software

Extracting the package – opening the installable

Starting the installation

Index

Index

SCD2 (version number) – I need my ancestors!

To implement SCD2 using the wizard, perform the following steps:

In the Designer, navigate to Tools | Mapping Designer | Mapping | Wizard | Slowly Changing Dimensions, as shown in the following screenshot:
A new window will pop up, asking you the name of the new SCD mapping (m_SCD2_VERSION_NUMBER). Also, select the type of SCD you wish to implement. Select Type 2 Dimension - keep a full history of the changes in the target, as we are implementing SCD2 using a version number. Click on Next.
The next screen will ask you to select the source. Select a source from the drop-down list. We are using EMP_FILE.txt as the source file for our reference. Also, specify the name of the target you wish to create. We will name the target EMPLOYEE_SCD2_VERSION_NUMBER in this book for our reference. Then, click on Next.
In the next window, select EMPLOYEE_ID as Logical Key Field. Also, add LOCATION under Fields to compare the changes, and then click on Next.
The next...

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 9.x

Search

Your notes and bookmarks