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

-

Nettundervisning Sentrum 4 dager 24 900 kr
12 Jan
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   Covid- 19 og klasseroms-kurs  Maks 12 deltakere per kurs Tilgang til antibac. 2 meter avstand mellom pultene. Pultene og stasjonære PC vil daglig bli sterilisert. Fri avmelding, ved symptomer på Covid-19, frem til kursstart.  OBS! Til et redusert pris kan du også melde deg på virtuellt fra f.eks.hjemmekontor. 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
Nettundervisning Sentrum 4 dager 24 900 kr
26 Jan
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 in English with an Norwegian Instructor, 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. 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.