Difference Stage in Datastage

Difference Stage in Datastage

The Difference stage in DataStage allows comparing two incoming data sets records by records. The two dataset must be of same metadata or before and after data sets .the records are compared, and additional column is added to output which maintains the difference code.

Example:

Before dataset:

EMPID SALARAY DEPT
1 1000 IT
2 200 HR
3 300 IT
4 400 CA
5 500 HR

After Dataset:

EMPID SALARAY DEPT
1 200 IT
2 200 HR
3 300 IT
4 400 CA
5 5000 HR

 

Consider changes are being captured on all columns

Output dataset:

EMPID SALARAY DEPT Change_code
1 200 IT 2
2 200 HR 3
3 300 IT 3
5 5000 HR 2
4 400 CA 3

Properties :

Category/Property Values
Difference Keys/Key Input Column
Difference Keys/Case Sensitive True/False
Difference Values/All non-Key Columns are Values True/False
Difference Values/Case Sensitive True/False
Options/Tolerate Unsorted Inputs True/False
Options/Log Statistics True/False
Options/Drop Output for Insert True/False
Options/Drop Output for Delete True/False
Options/Drop Output for Edit True/False
Options/Drop Output for Copy True/False
Options/Copy Code number
Options/Deleted Code number
Options/Edit Code number
Options/Insert Code number

Share this post

Leave a Reply