| 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; www.PacktPub.com; 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 |
|
English |
|
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 |
|
1782176497 |
|
