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

-

3 dager 22 500 kr
Kurset gir grunnleggende kunnskap for administrasjon og installasjon av PowerCenter10. Undervisningen består av teoriavsnitt som avsluttes med praktiske oppgaver. [+]
Course Objectives After successfully completing this course, students should be able to: Describe core administration tasks and tools Configure the Informatica Administrator tool Create and configure necessary services Plan and implement a backup strategy Manage Informatica security Audit security access and privileges Perform ongoing maintenance Stop or recycle a service Review domain logs Perform license management Agenda 1. PowerCenter 10 Architecture This module is intended to describe the Informatica PowerCenter 10 technical architecture, describe the Informatica domain, nodes, and an overview of the application services. The module also provides an overview of the PowerCenter clients 2. Best Practices Describes the use of best practices 3. Installing Informatica 10 Describes installing Informatica 10 domain and clients 4. Using the Informatica Administrator tool Describes the Administrator tool layout 5. Configuring PowerCenter Application Services Describes adding, configuring and managing a PowerCenter Repository Service and repository. Describes adding, configuring and managing a PowerCenter Integration Service 6. Users and Groups Describes how to add users and groups to the Informatica Platform 7. Privileges and Roles Describes how to create a custom role and assign privileges and roles to users and groups 8. Permissions Describes how to use Informatica permissions   General information: GENERAL The course is taught in local language, the course material is written in English. Course includes plenty of hands-on exercises. Course price includes course material and catering (coffees, lunch) daily. CGI reserves the right to make changes to courses and schedules. CGI may cancel a course if there are less than six (6) participants. CGI is not responsible for any expenses related to course cancellation. This course can also be arranged onsite at customer location.   OM CGI   CGI Group Inc. ble grunnlagt i 1976 og er verdens femte største uavhengige leverandør av tjenester innen IT- og forretningsprosesser. Med 74 000 medarbeidere over hele verden, leverer CGI en portefølje av ende-til-ende løsninger innen avanserte IT- og forretningskonsulenttjenester, systemintegrasjon og utsetting av IT- og forretningsprosesser. CGIs modell med kundenærhet, et globalt leveransenettverk og egne løsninger bidrar til at kundene hurtigere oppnår resultater og bidrar til deres digitale transformasjon. CGI har en samlet årlig omsetning på over 60 milliarder NOK. CGI-aksjene er notert på TSX (GIB.A) og NYSE (GIB). Hjemmeside: www.cginorge.no  [-]
Les mer
Oslo 4 dager 27 500 kr
PowerCenter Level One Developer [+]
  This Powercenter developer course gives you an introduction to Informatica PowerCenter version 10.X 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. CGI reserves the right to make changes to courses and schedules. CGI may cancel a course if there are less than six (6) participants. CGI is not responsible for any expenses related to course cancellation. This course can also be arranged onsite at customer location   OM CGI   CGI Group Inc. ble grunnlagt i 1976 og er verdens femte største uavhengige leverandør av tjenester innen IT- og forretningsprosesser. Med 74 000 medarbeidere over hele verden, leverer CGI en portefølje av ende-til-ende løsninger innen avanserte IT- og forretningskonsulenttjenester, systemintegrasjon og utsetting av IT- og forretningsprosesser. CGIs modell med kundenærhet, et globalt leveransenettverk og egne løsninger bidrar til at kundene hurtigere oppnår resultater og bidrar til deres digitale transformasjon. CGI har en samlet årlig omsetning på over 60 milliarder NOK. CGI-aksjene er notert på TSX (GIB.A) og NYSE (GIB). Hjemmeside: www.cginorge.no  [-]
Les mer
4 dager 27 500 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.   OM CGI CGI Group Inc. ble grunnlagt i 1976 og er verdens femte største uavhengige leverandør av tjenester innen IT- og forretningsprosesser. Med 74 000 medarbeidere over hele verden, leverer CGI en portefølje av ende-til-ende løsninger innen avanserte IT- og forretningskonsulenttjenester, systemintegrasjon og utsetting av IT- og forretningsprosesser. CGIs modell med kundenærhet, et globalt leveransenettverk og egne løsninger bidrar til at kundene hurtigere oppnår resultater og bidrar til deres digitale transformasjon. CGI har en samlet årlig omsetning på over 60 milliarder NOK. CGI-aksjene er notert på TSX (GIB.A) og NYSE (GIB). Hjemmeside: www.cgi.com [-]
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.