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 /

Mostrar otras versiones (1)

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...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Malewar, Rahul (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, England : Packt Publishing, 2014.
Colección:Professional expertise distilled.
Temas:
Web sites > Design.
Sites Web > Conception.
COMPUTERS > Data Processing.
Web sites > Design
Acceso en línea:Texto completo
Texto completo
Tabla de Contenidos:
  • 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

Ejemplares similares