舉報

會員
Learning Informatica PowerCenter 9.x
最新章節:
Index
IfyouwishtodeployInformaticainenterpriseenvironmentsandmakeacareerindatawarehousing,thenthisbookisforyou.Whetheryouareadeveloperwho'snewtoInformaticaoranexperiencedprofessional,youwilllearnallthefeaturesofInformatica.Basicknowledgeofprogramminganddatawarehouseconceptsisessential.
最新章節
- Index
- Starting the installation
- Extracting the package – opening the installable
- Downloading the Informatica PowerCenter software
- Informatica installation – the prerequisites
- The Informatica architecture
品牌:中圖公司
上架時間:2021-08-06 19:05:19
出版社:Packt Publishing
本書數字版權由中圖公司提供,并由其授權上海閱文信息技術有限公司制作發行
- Index 更新時間:2021-08-06 19:41:59
- Starting the installation
- Extracting the package – opening the installable
- Downloading the Informatica PowerCenter software
- Informatica installation – the prerequisites
- The Informatica architecture
- Appendix A. Installing Informatica and Using Informatica Administration Console
- Summary
- Pushdown optimization
- Working on partitioning
- Bottlenecks
- Chapter 9. Optimization – Performance Tuning
- Summary
- Take me to next stage – deployment or migration
- Configuring the client tools
- Using Repository Manager
- Chapter 8. The Deployment Phase – Using Repository Manager
- Summary
- Tracing levels
- Types of lookup cache
- Transaction Control transformations
- The Stored Procedure transformation
- The Normalizer transformation
- The Update Strategy transformation
- The Lookup transformation
- Classification of transformations
- Source Qualifier transformation
- Union transformation
- The Joiner transformation
- The Sequence Generator transformation
- The Rank transformation
- The Router transformation
- The Filter transformation
- The Sorter transformation
- The Aggregator transformation
- Using the expression editor
- Ports in transformations
- The Expression transformation
- Creating the transformation
- Chapter 7. The Lifeline of Informatica – Transformations
- Summary
- Common errors
- Viewing session run properties
- Viewing workflow run properties
- Working with the session log
- Working with the workflow log
- Viewing the session log and workflow log
- The status of workflows and tasks
- Stopping or aborting the workflow or task
- Running or recovering workflows or tasks
- Opening previous workflow runs
- Connecting to the Workflow Manager screen
- Using Workflow Monitor
- Chapter 6. Monitoring Your Code – Using the Workflow Monitor Screen
- Summary
- The parameter file – parameters and variables
- Incremental aggregation
- File List – the indirect way
- Schedulers
- Worklets – groups of tasks
- The link task
- Event tasks – event wait and event raise
- The decision task
- The control task
- The timer task
- The assignment task
- The e-mail task
- The command task
- The session task
- Configuring a task
- Working with tasks
- Chapter 5. Using the Workflow Manager Screen – Advanced
- Summary
- Working with connection objects
- Trigger – starting a workflow
- Deleting a workflow
- Assigning Integration Service to a workflow
- Connecting the tasks – links
- Working with the session task – basic properties
- Adding tasks in a workflow
- Creating a workflow
- Using Workflow Manager
- Chapter 4. Finishing the Development – Using the Workflow Manager Screen Basics
- Summary
- SCD3 – store something if not everything!
- SCD2 (date range) – marking the dates
- SCD2 (flag) – flag the history
- SCD2 (version number) – I need my ancestors!
- SCD1 – I hate history!
- Chapter 3. Implementing SCD – Using Designer Screen Wizards
- Summary
- Comparing objects
- I hate hardcoding – parameters and variables
- Managing constraints – the target load plan
- Reuse me please – reusable transformation
- Debug me please – the debugger
- Chapter 2. Using the Designer Screen – Advanced
- Summary
- The Designer screen's components
- Informatica PowerCenter Designer
- Chapter 1. Starting the Development Phase – Using the Designer Screen Basics
- Customer support
- Reader feedback
- Conventions
- Who this book is for
- What you need for this book
- What this book covers
- Preface
- Support files eBooks discount offers and more
- www.PacktPub.com
- About the Reviewers
- Acknowledgments
- About the Author
- Credits
- Learning Informatica PowerCenter 9.x
- coverpage
- coverpage
- Learning Informatica PowerCenter 9.x
- Credits
- About the Author
- Acknowledgments
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Chapter 1. Starting the Development Phase – Using the Designer Screen Basics
- Informatica PowerCenter Designer
- The Designer screen's components
- Summary
- Chapter 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
- 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
- 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
- Chapter 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
- Chapter 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
- Chapter 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
- Chapter 8. The Deployment Phase – Using Repository Manager
- Using Repository Manager
- Configuring the client tools
- Take me to next stage – deployment or migration
- Summary
- Chapter 9. Optimization – Performance Tuning
- Bottlenecks
- Working on partitioning
- Pushdown optimization
- Summary
- Appendix 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 更新時間:2021-08-06 19:41:59