Books+ Search Results
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
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.
ISBN
9781782176497
1782176497
1782176489
9781782176480
Publication
Birmingham, England : Packt Publishing, 2014.
Copyright Notice Date
©2014
Physical Description
1 online resource (362 pages) : color illustrations.
Local Notes
Access is available to the Yale community.
Notes
Includes index.
Access and use
Access restricted by licensing agreement.
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.
Variant and related titles
O'Reilly Safari. OCLC KB.
Other formats
Print version: Malewar, Rahul. 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. Birmingham, England : Packt Publishing, ©2014 Professional Expertise Distilled
Format
Books / Online
Language
English
Added to Catalog
January 14, 2020
Series
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
Also listed under
Safari Books Online (Firm)
Bookmark As
Citation
