by Rahul Malewar | Released August 2017 | ISBN: 9781787127852

Master the advanced aspects of the Informatica client to create reusable transformations and mappletsAbout This VideoWork with the advanced aspects of the Designer and Workflow Manager screensLearn how to work with various tasks in Informatica Power CenterCreate reusable transformations and mapplets with this handy guideIn DetailInformatica is a leader in the ETL market and provides lot of job opportunities in the industry. This course will give you basic to intermediate skills in Informatica, and will help you to prepare for the global certification in Informatica.You'll start the course by learning to debug a mapping, which will help you identify any issues in mappings. You'll be introduced to the advanced aspects of the Designer and Workflow Manager screens. Then you'll find out how to create reusable transformations and mapplets. Then, we move on to working with the target load plan and you'll learn to compare objects.The latter part of the course is centered around using the Workflow Manager screen. You'll learn about the various tasks that are present in Informatica along with the scheduling workflow. We'll also take a look at various aspects of the Admin Console, such as the Repository, Domain, Node, Integration Service, and more. Finally, we'll conclude the course with incremental aggregation, configuring file lists, and working with various types of partitions. Show and hide more

1. Chapter 1 : Reusable Transformations, Mapplets, and Debugger
   • The Course Overview 00:02:45
   • Creating Reusable Transformations 00:03:57
   • Creating Mapplets 00:02:21
   • Working With Debugger 00:06:18
2. Chapter 2 : Learning Advanced Aspects
   • Target Loan Plan 00:02:38
   • Comparing Objects 00:01:29
   • Dependencies 00:01:02
   • Tracing Level 00:02:49
3. Chapter 3 : Working With Tasks
   • Types Of Tasks 00:03:46
   • Command task 00:01:44
   • Email Task 00:01:37
   • Event Task 00:03:44
   • Timer Task 00:02:03
4. Chapter 4 : Working With Other Tasks
   • Link Task 00:01:45
   • Decision Task 00:02:02
   • Assignment Task 00:01:40
   • Control Task 00:02:34
   • Session Task Properties 00:16:49
5. Chapter 5 : Advanced Utilities Of Workflow Manager
   • Configuring internal Scheduler 00:02:34
   • Reusable Tasks 00:01:18
   • Worklets 00:01:29
   • Configuring File Lists 00:02:27
   • Working with Incremental Aggregation 00:02:52
   • Working on Parameter Files 00:07:08
6. Chapter 6 : Performance Optimization, Pushdown optimization, Partitioning
   • Performance Optimization 00:17:27
   • Partitioning 00:03:48
   • Pushdown Optimization 00:03:13
Show and hide more