Module 2: Designing your first job
You learned how to open, compile, and run the sample job. However, this job was prebuilt, so it is time to learn how to design your own job.
The job that you design in this tutorial reads two flat files and
populates two lookup tables. To better understand their customer demographics,
GlobalCo Worldwide wants to know where each customer lives and what
language they speak. Therefore, you create a lookup table that includes
a code that identifies which country the customer is from, in addition
to a code that indicates the language of each customer.
GlobalCo Worldwide also wants to know the interval at which customers receive shipments. Understanding the frequency and volume of shipments helps GlobalCo Worldwide to streamline their delivery operations and adjust production based on peak delivery times. To include this data, you create a second lookup table that includes a special handling code that is used in Module 3. This code corresponds to a text description that describes the interval of when each customer receives a delivery.
Learning objectives
After completing the lessons in this module, you understand how to complete the following tasks:- Add stages and links to a job
- Specify properties for stages and links to determine how they function when you run the job
- Import metadata for columns
- Add job parameters and create parameter sets
- Enhance your knowledge of compiling and running jobs