OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » Test Cases (SQL Developer, 3.2.20.09,Win 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Test Cases [message #577413]

Fri, 15 February 2013 02:05

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

Report message to a moderator

Re: Test Cases [message #577417 is a reply to message #577413]

Fri, 15 February 2013 02:49

Littlefoot
Messages: 21826
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.

Report message to a moderator

Re: Test Cases [message #577484 is a reply to message #577417]

Sun, 17 February 2013 00:37

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

Report message to a moderator

Re: Test Cases [message #577494 is a reply to message #577484]

Sun, 17 February 2013 09:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

are both SEARCH & GOOGLE broken for you?

http://www.orafaq.com/wiki/Test_case

Report message to a moderator

Re: Test Cases [message #577497 is a reply to message #577494]

Sun, 17 February 2013 09:30

Littlefoot
Messages: 21826
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?

Report message to a moderator

Re: Test Cases [message #577805 is a reply to message #577497]

Wed, 20 February 2013 14:01

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

Report message to a moderator

Previous Topic:	Loop and nested loop
Next Topic:	Oracle Developer job query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 21 21:28:06 CST 2026