Hi All,
I want to recruit QA team for Datastage what are all the criteria the testers require.
How do we test an ETL Datastage job,what are all the areas a tester should concentrate to test a job.
What are all the test cases he need to concentrate.
pl do the needful
Regards,
Saik.
Testing of Datastage jobs
Moderators: chulett, rschirm, roy
QA testing is usually to analyze the data being processed. For jobs, usually the ETL lead or architect who has prior solid development experience can analyze the jobs.
When i check jobs i look for points like ease of maintenance, check to see if there is a performance bottleneck and prefer modularization. Make sure all the jobs are parametrized properly. If multi-instance jobs are used, make sure the output files, if flat, are distinct so that overlapping of data does not occur. Stuff like that.
When i check jobs i look for points like ease of maintenance, check to see if there is a performance bottleneck and prefer modularization. Make sure all the jobs are parametrized properly. If multi-instance jobs are used, make sure the output files, if flat, are distinct so that overlapping of data does not occur. Stuff like that.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Like any QA person, an advanced sense of cynicism is essential. Skill in constructing test cases (you may need to create test data according to specifications) is also vital. Ultimately, testing not only needs to ensure that jobs finish OK, it needs to test that they produce correct results; that all their derivation and constraint expressions work properly.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
As your DS is on unix box, tester should have a bit of knowledge or exp in Unix commands - file handling usually. Then other things related files like FTP and if he can use any editor in unix like VI, it will be added advantage.
If in your project you deal with database as in most cases, he/she should SQL knowledge.
Other general things like - test data preparation as per the diff conditions.
If in your project you deal with database as in most cases, he/she should SQL knowledge.
Other general things like - test data preparation as per the diff conditions.
Regards,
S. Kirtikumar.
S. Kirtikumar.