
Tracking Changes in Source Datetime Values
Problem
You want to track changes to primary key values using begin and end datetime values.
Solution
You can create a job that uses a Key Effective Date transformation.
The sample job includes the following tasks:
• “Create and Populate the Job” on page 554
• “Identify Source Columns” on page 554
• “Run the Job and View the Output” on page 555
Tasks
Create and Populate the Job
Perform the following steps to create and populate a new job:
1. Create an empty SAS Data Integration Studio job.
2. In the Transformations tree, in the Data folder, drag the Key Effective Date
transformation into the empty job on the Diagram ...