DataStage job that compares rows

1. Create Parallel job that take data from 2 tables

2. Specify columns to compare 

 3. Specify mapping

4. Specify output that has CnageCode

  4. Add Basic transformer that can handle warnings.

DataStage create job that truncate table. Delete Data from table using DataStage job

Now I am working as ETL tester. Our main tool is IBM Datastage, so I will leave small tips to me for future development.

Here I provide steps.

1. Create parallel job 

2. Use Row Generator that generates 1 row for one column  

3. database connector(Oracle in my case)

4. Ctr+ J add parameter Table name

Save and compile job ) 

Have a nice day