Limit search to available items
Book Cover
Author Malewar, Rahul, author

Title Learning Informatica PowerCenter 9.x : learn the art of extracting data from disparate systems, integrating it using the leading data integration platform, and creating intelligent data centers for your business / Rahul Malewar
Published Birmingham, England : Packt Publishing, 2014


Description 1 online resource (362 pages) : color illustrations
Series Professional expertise distilled
Professional expertise distilled.
Contents Cover; Copyright; Credits; About the Author; Acknowledgments; About the Reviewers;; Table of Contents; Preface; Chapter 1: Starting the Development Phase -- Using the Designer Screen Basics; Informatica PowerCenter Designer; The Designer screen's components; Working with sources; Adding a new ODBC data source; Working with relational database tables -- the Import option; Working with flat files -- the Import option; Working with sources -- the Create option; Working with targets; Working with target relational database tables -- the Import option
Working with target flat files -- the Import optionWorking with the target -- the Create option; Working with the target -- the Copy option; A feel of the data inside the repository -- a preview; Previewing the source data -- flat files; Previewing the source data -- a relational table; Creating a database table; The skeleton -- a mapping; Summary; Chapter 2: Using the Designer Screen -- Advanced; Debug me please -- the debugger; Reuse me please -- reusable transformation; Using Transformation Developer; Making existing transformation reusable; Mapplet; Managing constraints -- the target load plan
I hate hardcoding -- parameters and variablesComparing objects; Summary; Chapter 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; Chapter 4: Finishing the Development -- Using the Workflow Manager Screen Basics; Using Workflow Manager; Creating a workflow; Creating a workflow manually; Creating a workflow automatically; Adding tasks in a workflow; Adding tasks to the workflow directly
Creating nonreusable tasks -- Task DeveloperAdding tasks to the workflow -- Task Developer; Working with the session task -- basic properties; Connecting the tasks -- links; Assigning Integration Service to a workflow; Deleting a workflow; Trigger -- starting a workflow; Running the complete workflow; Running a part of the workflow; Running a task; Working with connection objects; Creating a connection object; Configuring a relational database; Summary; Chapter 5: Using the Workflow Manager Screen -- Advanced; Working with tasks; Configuring a task; The session task; Tabs of the session task
Creating a session taskThe command task; Creating a command task; The e-mail task; Creating an e-mail task; The assignment task; Creating an assignment task; The timer task; Creating a timer task; The control task; Creating a control task; The decision task; Creating a decision task; Event tasks -- event wait and event raise; Creating an event (wait/raise) task; The link task; Creating a link task; Worklets -- groups of tasks; Creating a worklet; Schedulers; File List -- the indirect way; Incremental aggregation; The parameter file -- parameters and variables; Defining session-level variables
Summary 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
Notes Includes index
Online resource; title from PDF title page (ebrary, viewed January 14, 2015)
Subject Web sites -- Design.
COMPUTERS -- Data Processing.
Web sites -- Design
Form Electronic book
ISBN 9781782176497