Om kurset

This course teaches how to build QualityStage parallel jobs that investigate, standardize, match, and consolidate data records. This course covers common data quality issues, QualityStage architecture, QualityStage clients and their functions, importing metadata, running jobs and reviewing results, building Investigate jobs, the Standardize stage and rule sets, identifying matching records and applying multiple Match passes, building a Survive job, and using a Two-Source match.

Students will gain experience by building an application that combines customer data from three source systems into a single master customer record.

Virtual Learning

This interactive training can be taken from any location, your office or home and is delivered by a trainer. This training does not have any delegates in the class with the instructor, since all delegates are virtually connected. Virtual delegates do not travel to this course, Global Knowledge will send you all the information needed before the start of the course and you can test the logins.

Dette lærer du

After completing this course, learners should be able to:

• List common data quality contaminants
• Describe QualityStage architecture, clients, and their functions
• Build and run DataStage and QualityStage jobs and review results
• Use Character Discrete, Concatenate, and Word Investigations to analyze data fields
• Build jobs using the Standardize stage
• Build a QualityStage job to identify matching records
• Interpret, improve, and consolidate match results

Kursinnhold

Kurset dekker blant annet følgende temaer:

Data Quality Issues • Exercise 1: Pre-lab Prep
QualityStage Overview • Exercise 1: QualityStage Logon
Developing with QualityStage • Exercise 1: Import Table Definition Metadata
Exercise 2: Build a QualityStage Job
Investigate • Build Investigate Jobs
Standardize • Exercise 1: Standardize Country
Exercise 2: Select US Records
Exercise 3: Standardize USPREP
Exercise 4: Standardize USNAME, USADDR, and USAREA
Exercise 5: Investigate Unhandled Patterns
Exercise 6: Apply Rule Set Overrides
Match • Exercise 1: Create match Frequency Job
Exercise 2: One-source Match Specification
Exercise 3: Build a One-source Job using Match Specification
Survive • Exercise 1: Survivorship
Exercise 2: Create Customer Load File
Two-Sort Match • Exercise 1: Read the Case Study
Exercise 2: Prepare the Data Environment
Exercise 3: Run the Two-Source Match Job

Forkunnskaper

Participants should have the following skills:

• Familiarity with the Windows Operating System
• Familiarity with a text editor
• Helpful, but not required: Some understanding of elementary statistics principles such as weighted averages and probabilities.

Hvem passer kurset for?

• Data analysts responsible for data quality using QualityStage
• Data quality architects
• Data cleansing developers

Videre kurs

Not available. Please contact.

Kommende kurs

Kursdatoer

Ingen kommende kursdato er publisert ennå.

Kontakt oss for informasjon om neste gjennomføring.

SG Partner

Hvorfor velge SG Partner?

Vi gjør det enkelt å finne riktig kurs og riktig gjennomføring for deg og din virksomhet.

Offisielle kurs

Kursinnhold fra anerkjente teknologileverandører og fagmiljøer.

Erfarne instruktører

Praktisk og faglig undervisning med fokus på kompetanse du kan bruke.

Fleksibel gjennomføring

Velg mellom tilgjengelige virtuelle, fysiske og bedriftsinterne kurs.

Personlig rådgivning

Vi hjelper deg med å finne kurs og kompetanseløp som passer behovet ditt.

FAQ

Ofte stilte spørsmål

Hvor lenge varer kurset?

Kursets oppgitte varighet er 4.

Kan jeg ta en sertifisering?

Kurset kan være relevant som forberedelse til sertifisering. Se kursbeskrivelsen for informasjon om aktuell sertifisering og eksamen.

Hvilke forkunnskaper trenger jeg?

Participants should have the following skills: • Familiarity with the Windows Operating System • Familiarity with a text editor • Helpful, but not required: Some understanding of elementary statistics principles such as weighted averages and probabilities.

Hvem passer kurset for?

• Data analysts responsible for data quality using QualityStage • Data quality architects • Data cleansing developers

Kan kurset leveres som bedriftsinternt kurs?

Ja.

Hvor kan kurset leveres?

Kurset kan leveres over hele Norge, blant annet i Oslo, Kristiansand, Stavanger, Bergen, Trondheim og Tromsø.