I need some ideas for Unit testing our jobs. Basically, the job would have rules like this.
Code: Select all
1) Read all the records from source
- If Column A = 'X' Then
If Column C = 2, derive A= 23
Else If Column C = 3, derive A= 28
Else If Column C = 6, derive A= 28
Else If Column C = 9, derive A by performing a lookup
Else If Set A= 10
-Else Column A<> X Then
If Column C = 10, derive A= 27
Else If Column C = 3, derive A= 29
Else If Column C = 6, derive A= 28
Else If Column C = 9, derive A by performing a lookup
Else If Set A= 10
Unit testing this in Datastage by just merely running jobs, might be tough. I would like to test it via other tools commonly used. Please share your thoughts on this.
Thanks,
Meenakshi