IT-kurs
Kurs i programvare og applikasjoner
Informatica PowerCenter
Du har valgt: Oslo
Nullstill
Filter
Ferdig

-

2 treff ( i Oslo ) i Informatica PowerCenter
 

Oslo 4 dager 25 000 kr
PowerCenter Level One Developer [+]
This Powercenter developer course gives you an introduction to Informatica PowerCenter version 10.0.0. Powercenter is comprised of a server and client workbench tools that Developers use to create, execute, monitor and schedule ETL processes. You will work with the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools and perform tasks such as creating source and target definitions, transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data. Objectives After successfully completing this course, students should be able to: Utilize PowerCenter 10 Designer to build mappings that extract data from a source to a target, transforming it as necessary Deploy PowerCenter transformations to cleanse, format, join, aggregate and route data to appropriate targets Perform error handling/trapping using PowerCenter mappings Use PowerCenter 10 Workflow Manager to build and run workflows which execute sessions associated with a mapping and to control data transformation processes Design and build simple mappings and workflows based on essential business needs Complete basic troubleshooting using PowerCenter logs and debugger Delivery method This is a public classroom instructor-led training with around 60% lecture and 40% hands on lab. Target Audience Data Integration developers with little or no experience of PowerCenter Database Developers and developer Managers new to Informatica PowerCenter Prerequisites Windows GUI Understanding of RDBMS concepts Knowledge of SQL General Information   The course is taught in the local language, the course material is written in English. The course price includes course material and catering (coffees, lunch) daily. Affecto reserves the right to make changes to courses and schedules. Affecto may cancel a course if there are less than six (6) participants. Affecto is not responsible for any expenses related to course cancellation. This course can also be arranged onsite at customer location [-]
Les mer
4 dager 25 000 kr
PowerCenter Level 2 Developer [+]
This Informatica Powercenter developer Level 2 course extends the skills and knowledge of experienced Powercenter developers. Reviewing advanced topics with extended labs covering PowerCenter connection architecture, high availability, and session and workflow recovery. Objectives After successfully completing this course, students should be able to: Understand the Informatica PowerCenter architecture Determine the structure and use of PowerCenter Parameter Files Implement user-defined and advanced functions Normalize and Denormalize data using PowerCenter Use the Lookup transformation in Dynamic mode Call a SQL stored procedure from a PowerCenter mapping Create and configure a SQL transformation and its two modes of use Design error handling strategies appropriate for the intended purpose of a workflow Make use of the PowerCenter source-based, target-based, and user-based transaction control Utilize constraint-based loading in databases with referential integrity constraints Use the Transaction Control transformation for data-driven RDBMS transaction control Determine the proper use of built-in and optional, mapping-design recovery capabilities Build batch files that use PMCMD and PMREP command line programs Apply PowerCenter Performance Tuning Methodology Describe the effect of mapping design on performance and apply these design principles to a mapping Calculate how much memory a session uses and tune session-level memory. Apply partitions, distribute the data and optimize the CPU memory usage Delivery method This is a public classroom instructor-led training with around 60% lecture and 40% hands on lab. Target Audience Data Integration developers who have taken the PowerCenter 10 Developer, Level 1 Prerequisites Understanding of RDBMS concepts Knowledge of SQL Informatica PowerCenter v10 Developer, Level 1 It is highly recomended that you have worked with Powercenter at least 3-6 months before taking this class. General Information   The course is taught in the local language, the course material is written in English. The course price includes course material and catering (coffees, lunch) daily. Affecto reserves the right to make changes to courses and schedules. Affecto may cancel a course if there are less than six (6) participants. Affecto is not responsible for any expenses related to course cancellation. This course can also be arranged onsite at customer location. [-]
Les mer

Lukk Denne siden benytter seg av informasjonskapsler (cookies).
Du kan fortsette å bruke siden som vanlig hvis du godtar dette. Les mer om bruk av informasjonskapsler i vår personvernerklæring.
;