Home » Other » Training & Certification » Test Cases (SQL Developer, 3.2.20.09,Win 7)
Test Cases [message #577413] Fri, 15 February 2013 02:05 Go to next message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Hi
I'm working as an ETL developer and my responsibility is to load data in oracle table by using different conditions. Now my project manager want me to create test script/test case for all my tables that I successfully loaded in oracle tables. Can anyone guide me how to create test cases?. Thanks

Regards

Shumail
Re: Test Cases [message #577417 is a reply to message #577413] Fri, 15 February 2013 02:49 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Generally speaking, you'd provide CREATE TABLE statement, input data (such as a CSV file), script you used to load data (if it was SQL*Loader, you'd provide a control file). Optionally, take log files as well as files of bad and discarded records.

Though, I suppose that you'd rather ask your manager and ask him/her what exactly he/she expects so that you wouldn't waste your time doing something he/she doesn't want/need.
Re: Test Cases [message #577484 is a reply to message #577417] Sun, 17 February 2013 00:37 Go to previous messageGo to next message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Hi Littlefoot
Thanks for the reply, I asked this question to my manager and he told me the same thing that you advised above . In addition, if you can send me or refer me some sample or template for Test case then I really appreciate it. Thanks
Re: Test Cases [message #577494 is a reply to message #577484] Sun, 17 February 2013 09:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
are both SEARCH & GOOGLE broken for you?

http://www.orafaq.com/wiki/Test_case
Re: Test Cases [message #577497 is a reply to message #577494] Sun, 17 February 2013 09:30 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not sure what "sample" or "template" you expect; you should just provide stuff you work with every day. I don't have them, you do. What's the problem, really?
Re: Test Cases [message #577805 is a reply to message #577497] Wed, 20 February 2013 14:01 Go to previous message
shumail
Messages: 149
Registered: September 2012
Location: Canada
Senior Member
Thanks for the replies. I went through the provided link and it was good and gave me more idea about how to create test case.
@Littlefoot
actually I need some starting point to start use case and if I have some template or sample then I have got better idea to achieve my goal. Thanks
Previous Topic: Loop and nested loop
Next Topic: Oracle Developer job query
Goto Forum:
  


Current Time: Thu Mar 28 12:15:21 CDT 2024